This article was previously published under Q119472
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article describes how to use a previously defined import/exportspecification from one database in another database. Note that the methoddescribed 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 specificationin another database is to transfer the relevant system tables from onedatabase to another.
Import/export specifications are stored in the system tables MsysIMEXSpecsand MsysIMEXColumns. These two tables can be imported or exported, but thetarget 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/exportspecification, delete the existing MSysIMEXSpecs and MSysIMEXColumnstables in the new database, and then import those tables from the otherdatabase.
Importing an Import/Export Specification into a New Database
The following examples demonstrate how to import an import/exportspecification 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 MsysIMEXColumnstables from the original database to the new, blank database usingthe Export command on the File menu.
For more information about import/export specifications, search theHelp Index for "export to a text file," or ask the Microsoft Access 97Office Assistant.