Exporting to Another Access Database

You can easily export Access tables and queries to another Access database. The following is the required process:

  1. Right-click the object you want to export and select Export from the context menu. The Export Table dialog box appears.

  2. Select the Access database to which you want to export the object and then select Export. The Export dialog box appears (see Figure 18.1).

    Figure 18.1. The Export dialog box, which allows you to designate the destination table.


  3. In the Export dialog box, select Definition and Data or Definition Only, depending on whether you want to export just the structure or the structure and the data. Click OK.


When you export an object to another database, Access exports a copy of the object. When you choose Definition Only, Access copies just the object's structure (no data) to the receiving database.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics