Link a table from web page?

[Ivan]

Hello,

in Excel 2007 I can get the data or a table from web page with the help of a
wizard (Data/Get External Data/From Web). And I can later even refresh the
worksheet data with the original data.

I would like to have a similar situation/procedure in Access 2007. How can I
link to a table on web page from access? And how can I refresh the linked
table with the original data? Ok, I am seeing one possibility to use excel
data and excel automation. Is there any other easier way? I will be
grateful for any hint or a piece of code.

Ivan

 

[Mark A. Sam]

Ivan,

Just playing around, displayed ExternalData on the ribbon, on the Import
section click on More, then selected HTML document. That brought up the
wizard, but doesn't seem to offer a path to an internet page. Its a start.
Maybe you can take it farther, but I wouldn't expect it since no one
responeded to your post after a week.

Maybe you can link to the webpage through Excel then link to the spreadsheet
from Access.

God Bless,

Mark A. Sam