Jackpot – finally found answers of using SQL from an Excel workbook on the data IN THAT SAME workbook
In order of usefulness here are a set of links for myself to fully investigate. I did this before but if you use the wrong key words in Google – you pull up pupkis – now I used a different set of keywords and I pulled up a goldmine. Here they are in order of usefulness or in order of what I will try first. I want a solution with the least hassle for my customers to install on their own computers.
- Power Query – a Business Intelligence (BI) MS Excel plug in from Microsoft
- Power Query from someone else’s experience
- A plug in made by someone else that exposes .net functions to be used right in the queries
- it is called http://thingiequery.com/
- Using MSQuery – but it requires setup outside Excel
- SQL Queries tool
Maria
October 12, 2015Hello Etienne, it is so good to see the link to our SQL Queries tool in your blog! Whenever you want to give it a try, XLTools add-ins for Excel are easy to install and to use. I hope you will find it handy for your own professional use and for your customers as well.