Standard (HTML table) using Microsoft.Jet.OLEDB.4.0

Connection string

This Microsoft Jet OLE DB 4.0 connection string can be used for connections to HTML Table.

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.