ThingieQuery: a SQL plugin for Excel • Hacker News Board

Re: ThingieQuery: a SQL plugin for Excel

#61

Post by samstave » Fri, Jun 26, 2015, 9:38 PM UTC

anakic wrote: post #6

emailgregn wrote: post #3

I'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.

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$.

ExSQLence.com

Re: ThingieQuery: a SQL plugin for Excel

#62

Post by wanderingstan » Sat, Jun 27, 2015, 12:28 AM UTC

tokenizerrr wrote: post #29

retube wrote: post #26

This 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. https://support.google.com/docs/answer/3093343?hl=en

Wow, I never knew about this! Something I'm sure to use. Thanks.

Re: ThingieQuery: a SQL plugin for Excel

#63

Post by dgudkov » Sat, Jun 27, 2015, 2:09 AM UTC

Globz wrote: post #24

Very nice tool. It might become very useful at work if I can comvert all the heavy excel users towards SQL queries.

If SQL is hard for your users take a look at EasyMorph (http://easymorph.com). Disclaimer: I'm the author.

Re: ThingieQuery: a SQL plugin for Excel

#64

Post by howsta » Mon, Jun 29, 2015, 6:00 PM UTC

Gys wrote: post #12

bentronic wrote: post #7

I think the approach of https://airtable.com/ is a better solution for these kind of problems, but not everybody is free to change tools.

A lot of data is already in spreadsheets. And using an existing spreadsheet in AirTable is not quick and easy because its only possible with csv import: https://support.airtable.com/hc/en-us/articles/203423579-Imp... Strange they do not offer a more direct import. It would help the transition.

A bit late to the punch, but we also let you copy and paste from most other spreadsheet programs directly into Airtable

Re: ThingieQuery: a SQL plugin for Excel

#65

Post by anakic » Thu, Jul 02, 2015, 10:15 AM UTC

Hey Pete, I just wanted to say thanks for posting this, it was a huge deal for my page views. Between reddit and hackernews, my webpage went from having about 100 visitors/day to having 10k in a single day! Thanks a bunch, and if you tell me where you live (maybe via comments on my page), I'll make sure you get beer to delivered to your doorstep:)