Importing information from the web using URL

  • Thread starter Thread starter Scott Royster
  • Start date Start date
S

Scott Royster

How do I call a website to query information and import
the information using its URL?
 
Hi Scott,

I haven't experimented with this enough to be sure it works reliably,
but it seems that if the web page can be obtained by typing a URL you
can just pass the full URL (including the http://) in the FileName
argument of DoCmd.TransferText acImportHTML.

Obviously this can't work on pages where the URL doesn't change with the
data (i.e. many heavily scripted sites). In that case I think you'd need
to have the user navigate to the right data and then save the HTML to a
disk file from which Acces could import it.

It may also be possible to use a WebBrowser control on a form and write
code to make it make the website display the data you want; this gives
you access to the HTML.


How do I call a website to query information and import
the information using its URL?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Create an excel spreadsheet that uses a web query (your of
choice of url) then link this spreadsheet to the access DB.
Open the excel spreadsheet 'Refresh it !' save it and the
data is available to access.
 
Back
Top