HTML Table connection strings

Microsoft Jet OLE DB 4.0

  • Standard (HTML table)

    Yes, it is possible to query a html table using OLE DB!

    Provider=Microsoft.Jet.OLEDB.4.0;
    Data Source
    =http://www.websitewithhtmltable.com/tablepage.html;
    Extended Properties
    ="HTML Import;HDR=YES;IMEX=1";

    Use the following syntax: "Select * from [page title]" to query the html table at specified location.

    How to Use JET in 64 bit environments

Problems connecting?
Get answer in the HTML Table Q & A forum

.NET Framework Data Provider for OLE DB

  • Use an OLE DB provider from .NET

    Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

    See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

Q&Aask question »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.