So as a side project I developed a plugin that lets you do SQL inside Excel. It's called ThingieQuery (www.thingiequery.com).
When you install it, you get a SQL IDE window inside Excel. It uses an embedded SQLite engine to process the queries and uses the data from excel tables. Basically you get full SQL support inside excel.
In case you want to query your excel tables together with the tables on an external db server you can do that as well. In this case the data from Excel tables will be copied in the form of temp tables to the external server. If you wish, you can write the results of your queries back to Excel.
It has syntax highlighting, code completion (currently rudimentary tho), and can do some neat tricks which I won't go into here.
I've also made two tutorials so far:
https://www.youtube.com/watch?v=Ld-mbyAGsow
https://www.youtube.com/watch?v=1vjlEd2-bJQ
I created the licensing infrastructure and the website, and am trying to launch it as a product and I'd really appreciate any feedback.
If you do a lot of data manipulation in Excel and you're good with SQL do give it a try.
Thanks! Antonio
Bookmarks