MS Access and Internet - How to read the contents of html pages using visual basic

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to read the contents of html pages using visual basic

Werner Nussbaumer

2005-04-06, 8:05 pm

I'm trying to get a html document from an URL on the Internet into
access, without any interpretation. How can this be done with
Microsoft Access version >= 97?

I used for example

Set oHttp = CreateObject("Microsoft.XMLHTTP")
oHttp.Open "GET", "http://www.test.com/test/file.dat", False
oHttp.setRequestHeader "Content-Type", "text"
oHttp.send
fileList = oHttp.responseText
Set oHttp = Nothing

On some PCs this works, on some I get an error message for some files:

Run-time error '-2146697211 (800c0005)':
The system cannot locate the resource specified.

Is there an easier way?

Thanks for any help
regards
Werner Nussbaumer

Sponsored Links