AccessQueryAnalyzer Work Item Rss Feed

Commented Issue: Enhancement Request: Support for Access 2007

mangar00 — Mon, 27 Oct 2008 22:27:59 GMT

Access 2007 format is not recognized by the tool. An easy workaround is to save Access 2007 files in an earlier format, but adding support for 2007 would be a great feature.
Comments: ** Comment from web user: mangar00 **

You might be able to work around this with another tool, though might not be as nice or intuitive as this tool.

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

Just need to supply the OLE DB connection string for querying the Access mdb file.

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

mangar00 — Mon, 27 Oct 2008 22:04:19 GMT

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: ** Comment from web user: mangar00 **

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.

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

mangar00 — Mon, 27 Oct 2008 21:33:29 GMT

Created Issue: Enhancement Request: Support for Access 2007

DJGray — Sun, 31 Aug 2008 04:36:35 GMT

Access 2007 format is not recognized by the tool. An easy workaround is to save Access 2007 files in an earlier format, but adding support for 2007 would be a great feature.