How to export and import contract data using MS Access and CMTS.

Note: Modifying linked or attached table data may cause data loss.

First you must have:

1. Have MS Access Installed.
2. Know the location of your "Contract.mdb" file. Note: The file will be either on your hard drive on the network. 
3. Have the appropriate network permissions. Contact your network support for help.
 
Part A
1. Open MS Access, Create a blank database. Select a name for your new database. Remember the name, you will use this database as your interface to Contract Management Software.
2. In MS Access select "File" from the Menu.
3. Select "Get External Data", and then select "Link Tables".
4. Browse to the location of your "Contract.mdb" file. By default the file in stored in the following location "C:\Program Files\Contract Management Software\Contract.mdb".
5. Select the "Contract.mdb" file.
6. Select the "Select All" button. Next, Select "OK". The link to the table should appear in your new database.

Part B
7. Next, link all of the tables from the "Contract.mdb" file by selecting "Get External Data", and then select "Import Data".
8. Browse to the location of your "Contract.mdb" file. By default the file in stored in the following location "C:\Program Files\Contract Management Software\Contract.mdb".
9. Select the "Contract.mdb" file.
10. Select the "Table" Tab.
11. Select the "Select All" button. Next, Select "OK." The tables will now be linked (attached) to your new database.

Part C
1. To import data, open up the table you want to import data to and paste your data into the table. NOTE: Your fields must be in the same order as the fields in the linked table. Also, your field types and field lengths must be the same as the table definition.
2. You can now use Microsoft Access to view, edit, and delete the table data in the Contract.mdb tables.
3. Refer to your MS Access documentation for importing and exporting to Excel and how to create Queries and Reports. Below is a sample of how to use MS Access Report Wizard.

Create a report with a wizard

1. In the Database window, click the Reports tab.
2. Click New.
3. In the New Report dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.
4. Click the table or query that contains the data you want to base your report on. Note Microsoft Access uses this table or query as the default record source for the report. However, you can change the record source in the wizard and select fields from other tables and queries.
5. Click OK.
6. If you clicked Report Wizard, Chart Wizard, or Label Wizard in step 3, follow the directions in the wizard dialog boxes. If you click AutoReport: Tabular or AutoReport: Columnar, Microsoft Access automatically creates your report.
7. If the resulting report doesn't look the way you want, you can change it in Design view.