Link a table from web page?

  • Thread starter Thread starter Ivan
  • Start date Start date
I

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
 
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
 
Back
Top