Editing a Microsoft Query using the wizard

Modified on Sun, 19 Apr at 11:18 PM

The following example shows how to edit an existing query using the Query wizard, accessed from the Microsoft Excel spreadsheet created earlier.
Also, see:

To edit an existing query using the Query wizard:

Open the Microsoft Excel spreadsheet.
Right-click one of the populated cells and select Table > Edit Query from the menu.

Note: In Microsoft Excel 2003 right-click on one of the populated cells and select Edit Query from the menu.

Note: You can also refresh your dataset by selecting .

The SQL Server Login window is displayed.
Type in your username and password.

Note: This is your usual Synergetic username and password.
Click .
The Query Wizard - Choose Columns window is displayed.
Update the query using the Query Wizard windows. See Extracting data using the Microsoft Query wizard.
Click .
The Query Wizard - Finish window is displayed.
Select Return Data to Microsoft Office Excel.
Click .
Switch back to Microsoft Excel.
The dataset is refreshed with the latest parameters.