4 ms·
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:
by retube 11y ago
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.
- tokenizerrr 11y agoNot what you want, but Google docs has this and it's very nice. https://support.google.com/docs/answer/3093343?hl=en https://support.google.com/docs/answer/3093343?hl=en
- wanderingstan 11y agoWow, I never knew about this! Something I'm sure to use. Thanks.