Exporting the definition creates a blank copy of the table in the destination database.Įxporting a query, form, or report does not automatically export the underlying record sources. You can choose to export an entire table or just the table definition. If you want to import multiple tables and their relationship, open the destination database and import the objects. Since you can only export one table at a time, the export operation does not copy relationships. You cannot export a portion of an object or just a few selected records. The new linked table links directly to the Employees table in the Payroll database. The new linked table links to the original source table.įor example, if you export a linked table named Employees1 in the Sales database that is linked to the Employees table in the Payroll database, the export operation creates a linked table in the destination database. If the table that you want to export is a linked table, the export operation creates a linked table in the destination database. For more information, see the article Add records to a table by using an append query. To add records, consider creating an append query. Note: An export operation cannot add records to an existing table. You cannot export forms, reports and modules from an MDE or ACCDE file. If the file is in MDE or ACCDE format, the source object must be a table, a query, or a macro. The file format can be either MDB or ACCDB. Open the source database, if it is not already open. Looking for information about importing objects into an Access database? See Import database objects into the current Access database. Exporting does not offer you these options.
In addition to database objects, you can import relationships between tables, plus any import and export specifications, and menu bars and toolbars. If you want to export multiple objects to another database, it is easier to open the destination database and then perform an import operation from within that database. You can import multiple objects in a single operation, but you cannot export multiple objects in a single operation. The two main differences between importing and exporting objects between Access databases are: Note that exporting an object to another database differs very little from opening a second database and then importing the object from the first. To do this, you can create an export specification the first time you export the object, and then use the specification to repeat the operation later. You export database objects when you need to do any of the following tasks:Ĭopy the structure of a table to another database as a shortcut to creating a new table.Ĭopy the design and layout of a form or report to another database as a quick way to create a new form or report.Ĭopy the latest version of a table or form to another database at regular intervals. When you export an object, Access creates a copy of the object in the destination database. You can export a table, query, form, report, macro, or module from one Access database to another.
You can also save the details of the operation as an export specification for future use. For example, you can export the table definition and the data in the table, or export just the table definition (a blank copy of the table).
Copying and pasting an object is easiest, but exporting an object offers you more options. LessĪccess provides a number of ways to copy an object such as a table or form from one database to another. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.