3 ms·
I spent a lot of time in a previous life making huge queries in SQL and then dumping the un-normalized data into Excel to use its amazing Pivot functionality.
by gsiener 17y ago
I spent a lot of time in a previous life making huge queries in SQL and then dumping the un-normalized data into Excel to use its amazing Pivot functionality. I like the idea of this plugin, wish it worked the other way around!
- samh 17y agogsiener : Do you mean you wish you could use it to bring data from a SQL database into Excel rather than use SQL on Excel data ? I have considered adding this functionality, allowing the user to connect to any data source. It become pretty complex pretty quickly though, supporting a query that joins tables in different databases, with their different types, would be a big challenge.