Live Data from the web / Access Database

[jaxson]

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?

[Dolby Digital]

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.