All the screenshots seem to be based on Excel 2013. Is it compatible with earlier versions of Excel?
ThingieQuery: a SQL plugin for Excel
21–30 of 65 posts
Re: ThingieQuery: a SQL plugin for Excel
#22I don't know if it's a regional thing or what, but the idiom is usually "color me interested" rather than "paint me interested." Maybe you care, maybe you don't. I've just never seen "paint me interested" like that and thought it was curious.
Re: ThingieQuery: a SQL plugin for Excel
#23Earlier quoted context omitted.
Author here. I'm inclined to agree, the naming is poor, it didn't start out as a serious product, and I never changed the name. That said, you can at least use the trial licence (free for 30 days) and after that who knows, maybe I'll rename the plugin to Excel SQL Studio 3000 XT and add an Enterprise Ultimate Premier License for 1200$.
Personally I think the guy is a moron. If he wasn't banging his head so hard he might realize it's reasonably priced and he can save all the corporate hassle by purchasing it himself.
You say that as if his company would just allow him to use software he purchased himself...
Re: ThingieQuery: a SQL plugin for Excel
#24Very nice tool. It might become very useful at work if I can comvert all the heavy excel users towards SQL queries.
Re: ThingieQuery: a SQL plugin for Excel
#25I'm banging my head against Excel, wishing for SQL right now! But I could never go to my boss and ask for a purchase order for something called ThingieQuery. Give it a more bland gray name and make a massively expensive corporate site license available, and I think you're onto a winner.
+1 on the name...
Re: ThingieQuery: a SQL plugin for Excel
#26This is what I've wanted to do in excel since forever: a worksheet function that takes a range to use as the table and the SQL query as params, something like:
=QUERYTABLE("SELECT * FROM TABLE", A1:G1000)
Re: ThingieQuery: a SQL plugin for Excel
#27See also: textql - Execute SQL against structured text like CSV or TSV
Re: ThingieQuery: a SQL plugin for Excel
#28Looks interesting, how does this work under the hood? Does it use something like sqlite, or mssql? Because surely the syntax for queries is different, the page simply says it supports all SQL, but SQL can vary a lot between databases (or is it your own kind, and in that case yet another variant?)
Re: ThingieQuery: a SQL plugin for Excel
#29This is what I've wanted to do in excel since forever: a worksheet function that takes a range to use as the table and the SQL query as params, something like: =QUERYTABLE("SELECT * FROM TABLE", A1:G1000) I actually wrote my own in VBA that wrapped the ADO/JET db engine but involved writing out the table as a .csv in the background so I could query it. Would love a "proper" solution.
Not what you want, but Google docs has this and it's very nice.
Re: ThingieQuery: a SQL plugin for Excel
#30Earlier quoted context omitted.
Author here. I'm inclined to agree, the naming is poor, it didn't start out as a serious product, and I never changed the name. That said, you can at least use the trial licence (free for 30 days) and after that who knows, maybe I'll rename the plugin to Excel SQL Studio 3000 XT and add an Enterprise Ultimate Premier License for 1200$.
Personally I think the guy is a moron. If he wasn't banging his head so hard he might realize it's reasonably priced and he can save all the corporate hassle by purchasing it himself.
Enterprise doesn't work that way. There are a lot of situations where you aren't even allowed to use free-as-in-beer open source software due to security and/or other concerns, let alone software that you've paid for yourself. Besides, if the company is the one getting the benefit from the usage of the tool, why should he be the one paying for it?