1
Vote

Enhancement Request - support SQL queries of text, CSV, and Excel files via MS Jet data provider and ADO

description

This tool is great for SQL queries against Access databases. Unfotunately there isn't anything similar (or at least similar + free or open source) out there for doing the same thing with Excel, CSV, and delimited text files.
 
Since Access shares the same or similar SQL data provider (MS Jet), I don't think it's that much more work to add in support for these file formats as part of Access Query Analyzer.

comments

mangar00 wrote Oct 27, 2008 at 10:04 PM

Looks like I found a solution to my request here:

Query Express
http://www.albahari.com/queryexpress.aspx

Just need to supply the OLE DB connection string for querying Excel, CSV, and delimited text files.

wrote Feb 13, 2013 at 2:53 AM