Importing data from internet in Access database (Access 97)

Topic

New Reply

Hello All,
I have never done this before so I have no ideas at all…..Here is what I want to do:
A survey is being done….questionnires can be filled by people on paper or on a website…
I have a recept control system/…..the questionnaires returned by mail are entered into thissystem…..
In my system I have to give a form from where users can directly go to the adminstrative page of this website and download data .
How can I do it….?????
Any suggestions will be deeply apprecciated.

Thanks,
Isha

Reply | Quote

Replies

Could you be more specific about the help you need? Is your receipt control system an Access database, and are you asking for help with that? Or are you asking how to provide data to a website?

Reply | Quote

Charlotte,
Yes my receipt control system is a Access database. I need to provide some interface in my application so that by clicking on a command button user is able to go to the webpage of website that is doing websurvey and download a file directly into the system (IF possible)…..otherwise into an excel file and then I could import it into my system.
This website has provibed a option by which we can download the excel file.
I hope I have been able to explain it properly….otherwise plese let me know…
Thanks…..

Reply | Quote

Well, is the website data already set up? What data source does it have and what download options does it provide? There isn’t any magic that will allow you to download straight into the database. You still have to import the data into Access.

Reply | Quote

OK then I would do it in two steps:
Will have a form with two command buttons: One will take the user to this webpage…..the user will download the excel file.
Second button will import the excel file into access.
I need some help in writing the code for 1st button.
By using the wizard that comes up when you put a new command button on the form I have been able to open the explorer on click of this button….code is:

stAppName = “C:Program FilesInternet ExplorerIEXPLORE.EXE”
Call Shell(stAppName, 1)

How can I make this page to go directly to a particular web site say http:/ /www.cnn.com/

Isha

Reply | Quote

You’re almost there… try this (add the URL after the IEXPLORE.EXE):

stAppName = “C:Program FilesInternet ExplorerIEXPLORE.EXE http://www.cnn.com”
Call Shell(stAppName, 1)

Reply | Quote

Thanks it worked.
I just found out the easiest way to do it.
The Hyperlink address propert y of the command button can be used to set it up directly…..

Thanks a lot guys

Isha

Reply | Quote

The easiest way is to have no code behind the command button at all, but to enter the URL in the Hyperlink property of the command button. Clicking the button will automatically open this URL in the browser (even if it has been installed in another location, or has a different name).

Reply | Quote

Thanks Hans…..I think you posted your post while I was still composing mine….

Reply | Quote