Share via

Export database objects to an existing Microsoft Access database or Microsoft Access project

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  1. In the Database window, click the name of the object you want to export, and then on the File menu, click Export.

  2. Click the arrow to the right of the Save In box, and select the drive or folder where the Microsoft Access database you want to export to is located.

  3. Double-click the icon for the database that you want to export.

  4. In the Export dialog box, enter a name for the new object (or accept the current name). If you are exporting a table, in Export Tables, select whether you want to export both the table's definition and data or just the table's definition. Click OK to export the object.

Notes

  • You can only export tables to earlier versions of Microsoft Access.

  • When you export a table in an Access database, Microsoft Access exports only the table data and data definitions, not its properties (including constraints, relationships, and indexes).

  • Because Microsoft Access 2000 encodes data in Unicode format, data might get converted and changed when you export a table to a previous version. Learn about converting databases.

  • You cannot export views, stored procedures, and database diagrams to a Microsoft Access project or a Access database. You cannot export queries or relationships from an Access database to an Access project.

  • You can export only one object at a time. If you want to export several objects at one time, open the database you want to export to, and then import the objects instead. For more information, click aa831306(v=office.10).md.

  • When you export an object to another database, you might also want to export related objects to make it work. For example, a report might have a query as a record source, and that query might be based on a relationship between two tables.

  • When you export a data access page, you are exporting only the link to the corresponding HTML file. The HTML file remains in the same location, which means you have two data access pages pointing to the same corresponding HTML file. If you don't want this, save one of the data access pages under a different name (by using the Save As command on the File menu), enter a different file location for the new corresponding HTML file in the Save As Data Access Page dialog box, and then delete the data access page you just saved.