Developers community number 1 connection string reference

Connection strings 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
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
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";
 
Copyright © 2010 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.