If you have only Excel 2016, before you do anything else, please click here to vote to have the SQL editor restored. Microsoft Query interface tipsThe following features were cut from Microsoft Query 2011 and no longer work:There are no FIELD pop-up menus to display You can't SORT or add sort criteria for any chosen field using the GUI You can't FILTER data using a Filter in the GUI You can't Right-click a Table to DELETE it from your query Even if you scroll all the way to the right in this preview window, you may not be able to see all the columns returned by your query unless you move the mouse to the edge of the rightmost field name and discover the hidden arrow. 1 Open Excel to a blank workbook 2 From the DATA tab of the Ribbon click the Database button. The Microsoft Query dialog will open (see Figure 1) There is a main window divided into 3 panels: Tables, SQL Statement, and Result Set Preview. The GUI was cut from Microsoft Query 2016 If you do have Excel 2011, use that instead to generate your queries.
