Importing information from the web using URL

[Scott Royster]

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

 

[John Nurick]

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?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Ivan]

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.