Connection strings for HTML Table
Providers for HTML Table
Community Forums
Find solutions and post questions regarding connection string related issues.
Microsoft Jet OLE DB 4.0
Type
OLE DB Provider
Usage Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer Microsoft
Usage Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer Microsoft
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.
.NET Framework Data Provider for OLE DB
Type
.NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to Jet OLE DB 4.0
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.websitewithhtmltable.com/tablepage.html;Extended Properties="HTML Import;HDR=YES;IMEX=1";
Selected Articles