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.

You can use command-line parameters to launch Microsoft Excel from the Run dialog box or by configuring the command and switches in a desktop shortcut.

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 ...