Article ID: 208991 - View products that this article applies to.
This article was previously published under Q208991
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
This article shows you how to use a previously defined import/export specification from one database in another database.
NOTE: The method described in this article involves the manipulation of system tables. Although 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 and then import those tables from the other database.
Creating an Import/Export SpecificationTo create an Import/Export Specification in the sample database Northwind.mdb, follow these steps:
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
Importing an Import/Export Specification into a New DatabaseTo import an import/export specification into a new database, follow these steps:
For more information about import/export specifications, click Microsoft Access Help on the Help menu, type export a datasheet in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.