| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 46116 | 2004-06-14 03:01:00 | Live Data from the web / Access Database | jaxson (3204) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 244261 | 2004-06-14 03:01:00 | What's the easiest way to get live data into Access from a website? for example exchange rates from www.nationalbank.co.nz 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? |
jaxson (3204) | ||
| 244262 | 2004-06-14 06:15:00 | 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. |
Dolby Digital (160) | ||
| 1 | |||||