Need Access Connection String to HTML table

[markandjenn]

I am trying to build an access database that pulls in web data automatically for fantasy football. I am having a difficult time pulling in web data directly from the web. Currently, I have to pull it in to Excel via a web query and then import it into Access from there. The problem is that when I import it into Access from Excel I lose the hyperlinks.

I am importing may web pages of data, but below is an example of one of the many tables.

http://www.fftoolbox.com/football/strength_of_schedule.cfm?type=a

I am using the following code:


Dim cnn As New ADODB.Connection

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=URL;

http://www.fftoolbox.com/football/strength_of_schedule.cfm?type=a;Extended

Properties=HTML;HDR=no;IMEX=1;"

but I get the following error:

Run-time error '-2147467459 (80004005)
Could not find installable ISAM

Any help would be appreciated.

Thanks,
Mark