[AccessD] Read data off a live html table

Gustav Brock Gustav at cactus.dk
Tue Apr 4 09:15:08 CDT 2006


Hi all

Why can Excel read data from a live web page table just like that while Access can't?

Go to this page: 
  http://www.hdnl.co.uk/tracker.aspx?UPI=806290025850a

In IE, right-click on the table and choose Import in Excel, and in two seconds Excel opens with a worksheet with the linked data.

You can edit the query Excel uses and save it. This is it:

<iqy>
WEB
1
http://www.hdnl.co.uk/tracker.aspx?UPI=806290025850a 

Selection=1
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
</iqy>

If you use IE to save the page as a single html page, Access can link to that fine, so data is valid.
Any tricks for the live link? 

/gustav




More information about the AccessD mailing list