Recently I've taken some minor steps into the wide world of databases to give Excel a helping hand. I'll be honest and say I'm very much a beginner so don't expect much. I'm still learning the ins and outs of basic SQL.
Anyway, here's a little something I made on the weekend that allows you to perform simple queries within Excel itself. And it also allows to save your SQL queries so you can use them again later. (Forget indenting, go online or try your luck waiting for a later version!)
Assuming your data is in tables, you can select columns from sheets in your workbook, to insert the sheet (table) name and column (field) name directly into your SQL.
To be honest, it's half useful (for me at least, I can use it at work), and half experimental (as I'm still taking baby steps, I'm seeing what I can actually do with it).
Here's the download link.
See you next time. (I may or may not be be busy making Japanese versions of my add-ins for a week or two)