Importing from Another Access Database

You can import objects (for example, tables, queries, reports) from one Access database into another. When you import an object, you are making a copy of the object. Any changes you make to the imported object do not affect the original object.

To see how to import an Access table object, follow these steps:

  1. Open the database into which you want to import the table.

  2. Right-click anywhere in the Database window and select Import from the context menu. The Import dialog box appears.

  3. Select the folder where the Microsoft Access database you want to import is located.

  4. Double-click the database file that contains the object you want to import.

  5. Select the Table tab from the Object window.

  6. Select the table from the list of tables.

  7. Click the Options button.

  8. Select the desired options. Options include whether to import relationships, menus, and toolbars, as well as import and export specifications. You can also designate whether to import just the table definitions or the table definitions and the data. Finally, you can opt to import the queries as either queries or as tables (the result of executing the queries). Generally, you will leave all these options at their default values, although you might want to modify them for specific applications.

  9. Click OK.

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