Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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.
  6. Click .
    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.