Skip to end of banner
Go to start of banner

Updating MS Query queries for the single database structure

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

To update an MS Query for the single database structure:

  1. Open Microsoft Excel.
  2. Create an MS Query for either:
    • SynergyOne
    • SynergyOneFinance
    • SynergyExtraFinance.
    See Extracting data using the Microsoft Query wizard.

  3. Click the Data tab.
  4. Click Connections.
    The Workbook Connections window is displayed.
  5. Select the query.
  6. Click Properties....
    The Connection Properties window is displayed.
  7. Click the Definition tab.
    The Definition tab is displayed.


  8. Update:
    • DSN to Synergetic
    • DATABASE to the single database name. For example, Synergetic_AUVIC_CDA_TST.
  9. Click .
    The SQL Server Login window is displayed.
  10. Type your username into the Login ID field.
  11. Type your password into the Password field.
  12. Click .
    The following error is displayed.
  13. Click .
  14. Repeat steps 5 through 7.
  15. Update the database in the Command text field.

    Note: You need to replace the dbo to extrafinance if you are updating a SynergeticExtraFinance MS Query query.
  16. Click .
  17. Repeat steps 2 through 16 to update additional MS Query queries.
  18. Click Save.


  • No labels