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