How do I retrieve information from a web page?

H

Hrt

I am trying to get information from a particular part of a web page and put
it into Access 2002. Although very new to Access, I am familiar with Excel.
I am trying to do in Access what would be called a "Web Query" in Excel.

I have tried using File > Get External Data > Import, but it does not seem
to accept an http address in the file name box.

What is the best way, or at least one way, to retrieve a particular table
from a website and use it to populate a field in the database table?
 
F

freakazeud

Hi,
this is not that easy with access. Unless you have a direct xml feed from
the provider you need to "scrape it" of the screen. This is sort of a fairly
unreliable method especially if at some point the design of the website you
are scraping things of changes. However, it is doable and if you test it
enough and make sure that the source data stays formatted the same then you
can achieve it with some code. I posted a fairly detailed step by step
tutorial on how to achieve something like this here:
http://www.utteraccess.com/forums/s...=m&olderval=&oldertype=#Post1135275&bodyprev=
This is one way to do it...there are several others.
HTH
Good luck
 
E

Ed Warren

KISS
If you know how to get the data into Excel, then go there first, then import
the Excel file into Access

Ed Warren.
 
Top