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
More info and provider downloads

Set example values

Standard

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 »

 
 

.NET Framework Data Provider for OLE DB

Type .NET Framework Wrapper Class Library
 Usage System.Data.OleDb.OleDbConnection
 Manufacturer Microsoft
More info and wrapper class library downloads

Set example values

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.

 
 

Popular