Query Editor Add-In
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 |
Rob,
Excellent to see this post about Your nice utility
It works well with my Swedish version as well as Finnish version.
Kind regards,
Dennis
Looks very good Rob.
What SQL editors are poeple useing? Last time i did any SQL work (a long time ago) i use a thing called “TOAD”
I use (and love) PL/SQL Developer
It’s geared toward Oracle Developers and (IMO) is well-priced - with excellent support.
I’ve used Toad - it didn’t fly my kite but I know Oracle Consultants who always use it.
My workmate (DBA) uses SQL Navigator and he loves it.
Oracle really is a damn fine database.
Oracle is case sensitive, picky and sluggish, a real annoyance.
Just for the balance
Best wishes Harald
Thanks Harald
I believe that Oracle is like other databases & softwares/tools, some people love it while other hate it and the largest group is between these two points
Kind regards,
Dennis
I like =SQL.Request( ). I used it tonnes a while back when I needed a lot of little bits of data like a summary sheet.
You can use it for building a report with all the yucky formatting that users tend to like and the SQL is there in the formula for all to see.
I knock together a quick little xlPasteSpecial and I have an instant batch of reports for the morons to read.
(needless to say you have to run the ODBC addin)
P.S. I always try to write my own SQL by hand. That way you remeber which tables to join and can speed up the efficiency.
I tried to download the Query editor and ended at Van Gelder webstite which is teh web site of one of the people that have left comments.
Sorry, I’m having trouble with my web page.
You can download the program. Click here
It’s now at vangelder.orconhosting.net.nz/excel/queryeditor.html