Article ID: 119472 - View products that this article applies to.
This article was previously published under Q119472
Moderate: Requires basic macro, coding, and interoperability skills.
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.
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 DatabaseThe following examples demonstrate how to import an import/export specification into a new database.
In Microsoft Access 7.0 and 97:
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.
Article ID: 119472 - Last Review: January 19, 2007 - Revision: 2.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.