How to run a SQL query on an Excel table

Question

I'm trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn't null. I could do this pretty easy with SQL, but I have no clue how to go about running a SQL query within Excel. I'm tempted to import the data into postgresql and just query it there, but that seems a little excessive.

For what I'm trying to do, the SQL query SELECT lastname, firstname, phonenumber WHERE phonenumber IS NOT NULL ORDER BY lastname would do the trick. It seems too simple for it to be something that Excel can't do natively. How can I run a SQL query like this from within Excel?

Answer 1

On Excel tables, how to construct and run SQL SELECT
On the XLTools tab, click the Execute SQL button. The editing window will appear on the screen.
A tree view of all accessible tables can be found on the left-hand side.
You can choose to select entire tables or single fields.
Choose whether the query output should be placed on a new or existing worksheet.
To begin, press the Run button.