Import from Web into Table

[ryguy7272]

Is there a way of doing a web query with Access? I wanted to import data
from the web, into various tables, similar to the way Excel imports data from
the web, into various sheets. Does anyone know how to do this, or does
anyone know of a resource on the web that describes how to do this? How can
I link the table from a web page? How do I enter a web address? I tried to
save the page as an HTML file and import it, but it keeps crashing Access;
running 2003.


Regards,
Ryan--

 

[Alex Dybenko]

Hi,
not sure there are something built-in in access, for simple table you can
use something like this:
http://accessblog.net/2007/10/using-httpxml-to-get-data-from-web.html


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[ryguy7272]

This looks very cool. I am not sure how to use it though. I just learned
how to use a TextBox to call a function with a Form. I don't think that will
work for me this time though. How can I use this function? How do I call
it. Please give me a little more instruction. Thanks in advance!!

Regards,
Ryan--

 

[Alex Dybenko]

Hi,
this function just loads html page from some url, then you have to write
some code to get data from it. but implementation depends on data you want
to retrieve

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com