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
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:
- 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.
- On the File menu, point to Get External Data, and then click Import.
- On the Import page, click the Microsoft Access database with the desired import/export specifications, and then click Import.
- On the Import Objects screen, click Options.
- 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:
- Open the database containing the import/export specification you want
to import into another database.
- On the View menu, click Options. In the Category box, select
General, and then set the Show System Objects item to Yes. Click OK.
- On the File menu, click New Database. Type a name for the new
database in the File Name box; then click OK.
- On the File menu, click Import.
- In the Data Source box, select Microsoft Access, and then click OK.
- In the File Name box, select the database that contains the import/
export specification you want to import, and then click OK.
- 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.
- Repeat step 7 using the MsysIMEXColumns table, and then click Close.
- 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.
For more information about import/export specifications, search the
Help Index for "export to a text file," or ask the Microsoft Access 97
Article ID: 119472 - Last Review: January 19, 2007 - Revision: 2.1
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
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.