Importing Data

Import data from previous versions of Calibration Control

If you have data in version 4 of Calibration Control or you want to migrate your data from an MS Access version to a SQL Version, the following instructions can help.

Choose Version

Begin the import process by selecting the Import Wizard in the Utilities menu and you will see the following dialog in you are using SQL Server. This dialog is skipped if you are not using SQL Server.

You have a choice of importing from the pervious version 4 Access database or from a version 5 Access database. Version 4 did not use SQL Server. The version 4 Access filename is usually 'cc2000.mdb' and the version 5 Access filename is usually 'apecal.mdb' (unless you changed either name).

Select the appropriate input format and click the [Next] button to move to the next step.

Source Directory

Click the [Browse] button and navigate to the Access file you need to import and then click [Next].

Transfer Data

Note that if you try to import records from the source database to the current database and the record already exists, the import process will ignore those records. For instance, if you are importing from a version 4 database and one of the equipment records has an ID of '121' and your current database has a MasterID of '121', then record 121 will be ignored. Therefore, correct ID discrepancies before transferring data.

Last updated: 6/13/2011

Compatibility: Calibration Control versions 5.x