The Query Wizard box will appear on the screen. Click and select the table in the data source that contains the fields you want to query with SQL and import into your Excel spreadsheet.

Type a quotation mark, and then type the full path to the Excel EXE file in the Shortcut input box. Microsoft Excel 2013 installs to C:\Program Files\Microsoft Office\Office15\excel.exe by default.

Web queries offer a handy way to import data from selected tables into a worksheet--but Excel isn't as accommodating as it should be, especially when it comes to parameters. These tricks will let ...