M
Martin Green
I'm trying (without success) to read data from a table on
a web page using ADO. There is an Extended Property
called "HTML Import" so I'm assuming it can be done, but
I can't find any info about it and I can't make my
efforts work. Got this far with the connection string:
<snip>
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=http://www.somename.com/webdata.htm;" & _
"Extended Properties=HTML Import;"
</snip>
....but I get an "Internet login failure" error. Supplying
my user id and password doesn't help - but I wouldn't be
able to do this for a third-party web page anyway.
If anyone has successfully done this, I'd really
appreciate some pointers.
a web page using ADO. There is an Extended Property
called "HTML Import" so I'm assuming it can be done, but
I can't find any info about it and I can't make my
efforts work. Got this far with the connection string:
<snip>
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=http://www.somename.com/webdata.htm;" & _
"Extended Properties=HTML Import;"
</snip>
....but I get an "Internet login failure" error. Supplying
my user id and password doesn't help - but I wouldn't be
able to do this for a third-party web page anyway.
If anyone has successfully done this, I'd really
appreciate some pointers.