Query Editor is something which I’ve commented about but never really made a main post on.
It’s an add-in I made for grouping all of the great External Data features into one convenient User Interface.
It’s like a little party where all the Excel database goodies are invited… except Microsoft Query.
Query Editor handles OLEDB and ODBC QueryTables.
OLEDB has things which ODBC doesn’t and vice versa. For example, OLEDB QueryTables can be saved as ODC files. ODBC supports the use of Parameters.
I favour ODBC QueryTables, but only because it supports Parameters. If OLEDB QueryTables (the newer technology) supported Parameters then I’d be there in a shot.
If ever you’ve struggled with Microsoft Query, Multiple QueryTables, Parameter Queries, or External Data in general, you’ll probably find this Add-In handy.
So break out your favourite SQL Editor, crank out some SQL and have fun.
Click for Full_Sized Images
ODBC Parameter Query
ODBC Parameter Query to a Stored Procedure