Previous icon

Next icon

Extracting data from the Synergetic database

You can extract data from the Synergetic database for your own purposes, using tools such as:

Views have been developed to make it easier to extract data. See Synergetic views.

Stored procedures have also been developed, particularly for extracting data for mail merge letters. See Using stored procedures to retrieve Synergetic data.

How to

Last modified: 23/09/2014 3:32:45 PM

In This Section

What's new to Extracting data

Synergetic views

Extracting data using the Microsoft Query wizard

Editing a Microsoft Query using the wizard

Common duplication problems

Inserting an existing SQL statement

Extracting data using Microsoft Query directly

Advanced Microsoft Query and SQL examples

Extracting data for Crystal Reports

Using stored procedures to retrieve Synergetic data

© 2016 Synergetic Management Systems. Published 16 September 2016.

Top of page