Is this even possible Doing with MS Access. May be advanced

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to import data from a web site. For example if you was to go
to TV guide or some other web site that you query info off there web site and
manipulate the data to be able to sort the web sites data into a access
table. If so, is there any examples of this out there on the web that would
illustrate or teach how to do this.

Thanks
 
It's possible, but it is a bit of a pain.

I showed one way to do it in my November, 2003 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html. Unfortunately, the sites
I used for illustration purposes have changed substantially since I wrote
the article, so I don't believe the sample actually works anymore. The gist,
though, is to download the page, and parse the HTML to extract the data in
which you're interested.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top