Editing a Microsoft Query using the wizard

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

Also, see:

• Extracting data using the Microsoft Query wizard
• Common duplication problems.

To edit an existing query using the Query wizard:

1. Open the Microsoft Excel spreadsheet.
2. Open the Query wizard.

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

   In Microsoft Excel 2003:

   • select Data > Import External Data > Edit Query

     

   • click on the External Data toolbar

     

   • right click on one of the populated cells and select Edit Query from the menu (Microsoft Excel 2003).

     

     Note: You can also refresh your dataset by selecting Refresh Data.

   The SQL Server Login window is displayed.

   

3. Type in your username and password.

   Note: This is your usual Synergetic username and password.

4. Click .

   The Query Wizard - Choose Columns window is displayed.

   

5. Update the query using the Query Wizard windows. See Extracting data using the Microsoft Query wizard.
6. Click .

   The Query Wizard - Finish window is displayed.

   

7. Select Return Data to Microsoft Office Excel.
8. Click .
9. Switch back to Microsoft Excel.

   The dataset is refreshed with the latest parameters.

Last modified: 30/03/2017 3:21:25 PM

© 2017 Synergetic Management Systems. Published 20 July 2017.