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
• 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 Right-click one of the populated cells and select Table >Edit > Edit Query from the menu.
   Image Added
   
   Note: In Microsoft Excel 2003 :
   • select Data > Import External Data > Edit Query
    Image Removed
   • click Image Removed on the External Data toolbar
   Image Removed
   • right right-click on one of the populated cells and selectEdit  Edit Query from the menu (Microsoft Excel 2003).
   Image Removed
   
   Note: You can also refresh your dataset by selecting Refresh Data Image Added.
   
   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 .
   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.Click
6. AnchorO_13312O_13312Click .
   The Query Wizard - Finish window is displayed.
   Image RemovedImage Added
7. Select Return Data to Microsoft Office Excel.
8. Click .
9. Switch back to Microsoft Excel.
   The dataset is refreshed with the latest parameters.