Page Comparison

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
    Image RemovedImage Added
   • click Image Removed Image Added on the External Data toolbar
   Image RemovedImage Added
   • right click on one of the populated cells and select Edit Query from the menu (Microsoft Excel 2003).
   Image RemovedImage Added
   Note: You can also refresh your dataset by selecting Refresh Data.
   The SQL Server Login window is displayed.
   Image RemovedImage Added
   
3. Type in your username and password.
   Note: This is your usual Synergetic username and password. 
4. Click Image Removed Image Added.
   The Query Wizard - Choose Columns window is displayed.
   Image RemovedImage Added
5. Update the query using the Query Wizard windows. See Extracting data using the Microsoft Query wizard AnchorH_15099H_15099 (on page ).
6. Click

   Anchor
   O_13312 O_13312

   Image Removed Image Added.
   The Query Wizard - Finish window is displayed.
   Image RemovedImage Added
7. Select Return Data to Microsoft Office Excel.
8. Click Image RemovedImage Added.
9. Switch back to Microsoft Excel.
   The dataset is refreshed with the latest parameters.