Connection strings for HTML Table

OLE DB providers for HTML Table

.NET libraries for HTML Table

Microsoft Jet OLE DB 4.0

Type OLE DB Provider
Usage Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer Microsoft


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

Data Source=;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 »


.NET Framework Data Provider for OLE DB

Type .NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft

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.