Skip to end of banner
Go to start of banner

Editing a Microsoft Query using the wizard

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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 (on page )
  • Common duplication problems (on page ).

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 (on page ).
  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. 
  • No labels