Results 1 to 2 of 2
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Cambridge, UK
    Thanked 3 Times in 3 Posts

    Importing Data from a Web Site into Access (2000 SP (Any))

    I have a need to collect data from a folder on a Server
    and have it automatically collected and then update Access with the data.
    The second part is simple.
    How can I get the data from the Server.
    This is not on a LAN, it will be a secure server on a dial in connection
    or possibly from a WEB Site.
    The server will have a secure login.
    Can I do this from Access using VBA, or will I need to
    use API calls as well?
    I am only interested in a fairly seamless solution to the automatic Login and Data retrieval.
    Once the file is back at the Client end, the local Access database
    can perform the required update easily.

    On a second point, we will also want at some point to send an entire
    data file back to the server, using the same automated route.
    Login, and transfer file to a specific folder on the Server.

    Any suggestions or examples will be very gratefully received.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Importing Data from a Web Site into Access (2000 SP (Any))

    There are a number of options - remote access, terminal services in Win 2000 Pro, and a similar service in WinXP Pro, to name a few - so the options are highly dependent on your server. If it's running LINUX then there aren't many options. And in most cases you should be able to write VBA to make things work pretty seamlessly from a user perspective using the shell command.

Posting Permissions

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