Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing data from internet in Access database (Access 97)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing data from internet in Access database (Access 97)

    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?
    Charlotte

  3. #3
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data from internet in Access database (Access 97)

    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.....

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing data from internet in Access database (Access 97)

    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.
    Charlotte

  5. #5
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data from internet in Access database (Access 97)

    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

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data from internet in Access database (Access 97)

    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)

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing data from internet in Access database (Access 97)

    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).

  8. #8
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data from internet in Access database (Access 97)

    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

  9. #9
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data from internet in Access database (Access 97)

    Thanks Hans.....I think you posted your post while I was still composing mine....
    :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •