/
Editing a Microsoft Query using the wizard

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:

To edit an existing query using the Query wizard:

  1. Open the Microsoft Excel spreadsheet.
  2. 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.

  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. 

Related content

Extracting data using Microsoft Query directly
Extracting data using Microsoft Query directly
Read with this
Updating MS Query queries for the single database structure
Updating MS Query queries for the single database structure
More like this
Extracting data from the Synergetic database
Extracting data from the Synergetic database
More like this
Extracting data using the Microsoft Query wizard
Extracting data using the Microsoft Query wizard
More like this
Extracting student name and contact details example
Extracting student name and contact details example
More like this
How to run an MS Query
How to run an MS Query
More like this