ACC: How to Use an Import/Export Specification in Another Database (119472)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
This article was previously published under Q119472
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

This article describes how to use a previously defined import/export specification from one database in another database. Note that the method described in this article involves the manipulation of system tables. While manipulating system tables is neither supported nor encouraged, the only method for using a previously defined import/export specification in another database is to transfer the relevant system tables from one database to another.

MORE INFORMATION

Import/export specifications are stored in the system tables MsysIMEXSpecs and MsysIMEXColumns. These two tables can be imported or exported, but the target database MUST NOT contain an existing import/export specification. If the target database already contains an import/export specification, additional tables that Microsoft Access does not recognize will be created.

The best approach is to create a new database for the import/export specification, delete the existing MSysIMEXSpecs and MSysIMEXColumns tables in the new database, and then import those tables from the other database.

Importing an Import/Export Specification into a New Database

The following examples demonstrate how to import an import/export specification into a new database.

In Microsoft Access 7.0 and 97:
  1. On the File menu, click New Database. Click Blank Database, and then click OK. Type a name for the new database in the File Name box, and then click Create.
  2. On the File menu, point to Get External Data, and then click Import.
  3. On the Import page, click the Microsoft Access database with the desired import/export specifications, and then click Import.
  4. On the Import Objects screen, click Options.
  5. Under Import, click to clear the Relationships check box. Click to select the Import/Export Specs check box, and then click OK.
In Microsoft Access 1.x and 2.0:
  1. Open the database containing the import/export specification you want to import into another database.
  2. On the View menu, click Options. In the Category box, select General, and then set the Show System Objects item to Yes. Click OK.
  3. On the File menu, click New Database. Type a name for the new database in the File Name box; then click OK.
  4. On the File menu, click Import.
  5. In the Data Source box, select Microsoft Access, and then click OK.
  6. In the File Name box, select the database that contains the import/ export specification you want to import, and then click OK.
  7. In the Object Type box, select Tables. In the Objects In <Database> box, select MsysIMEXSpecs and then click the Import button. Click OK when you are notified that the table was successfully imported.
  8. Repeat step 7 using the MsysIMEXColumns table, and then click Close.
  9. On the View menu, click Options. In the Category box, select General, and then set the Show System Objects item to No. Click OK.
NOTE: You can also export the MsysIMEXSpecs and MsysIMEXColumns tables from the original database to the new, blank database using the Export command on the File menu.

REFERENCES

For more information about import/export specifications, search the Help Index for "export to a text file," or ask the Microsoft Access 97 Office Assistant.
Modification Type:MajorLast Reviewed:5/6/2003
Keywords:kbhowto kbusage KB119472
©2002 Microsoft Corporation. All rights reserved.