Results 1 to 2 of 2
  1. #1
    jaxson
    Guest

    Default Live Data from the web / Access Database

    What's the easiest way to get live data into Access from a website? for example exchange rates from http://www.nationalbank.co.nz/person...ex/fxrates.asp

    I've tried creating a macro, using the TransferText method, but this expects a page with the suffix htm,html,txt, etc - (The example page is a .asp extension)

    It shouldn't be difficult - basically I need to run a procedure that updates the figures in a table.

    Any Ideas?

  2. #2
    Dolby Digital
    Guest

    Default Re: Live Data from the web / Access Database

    If you HAVE to give it an html extension file just rename the asp file to html (which it is anyway).

    You may have to parse the html page to remove all the html tags or can Access do this.

Similar Threads

  1. Access Database
    By Stu927 in forum PressF1
    Replies: 6
    Last Post: 03-12-2005, 10:44 AM
  2. Access 97 database
    By Steve in forum PressF1
    Replies: 1
    Last Post: 04-07-2002, 04:49 PM
  3. Access Database
    By DavidS in forum PressF1
    Replies: 6
    Last Post: 02-07-2002, 12:46 PM
  4. Access: Northwind Database?
    By in forum PressF1
    Replies: 0
    Last Post: 02-12-2001, 08:51 PM
  5. Replies: 0
    Last Post: 18-02-2001, 12:00 PM

Posting Permissions

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