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:

...

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
   

...

1.  Image Added
   • click Image Modified on the External Data toolbar
   

...

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

...

...

1. Image Modified
   Note: You can also refresh your dataset by selecting Refresh Data.
   The SQL Server Login window is displayed.

...

1. 
   Image Modified
   
2. Type in your username and password.
   Note: This is your usual Synergetic username and password. 
3. Click Image Modified .
   The Query Wizard - Choose Columns window is displayed.

...

...

1. Image Modified
2. Update the query using the Query Wizard windows. See Extracting data using the Microsoft Query wizard

   Anchor
   H_15099 H_15099

   (on page ).
3. Click

   Anchor
   O_13312 O_13312

   Image Modified.
   The Query Wizard - Finish window is displayed.

...

1. 
   Image Modified
2. Select Return Data to Microsoft Office Excel.
3. Click AnchorO_12623O_12623Click Image Modified.
4. Switch back to Microsoft Excel.
   The dataset is refreshed with the latest parameters.