Connection strings for HTML Table
Providers to use when connecting to HTML Table
Finding this site useful?
-Say "Thanks" to Marco Lanini and the other contributing developers!
-Thank you! »
-Say "Thanks" to Marco Lanini and the other contributing developers!
-Thank you! »
Microsoft Jet OLE DB 4.0
Type: OLE DB Provider
Usage: Provider=Microsoft.Jet.OLEDB.4.0
Usage: Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer: Microsoft
Customize string 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.
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Customize string example values »
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";