Microsoft Access 2010 : Sharing Data with Other Applications - Importing from Another Access Database

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

While viewing the list of tables, right-click anywhere within the Navigation Pane and select Import. (Alternatively, you can select Access from the Import & Link group on the External Data tab of the Ribbon.)

Select Access Database from the flyout menu. The Get External Data – Access Database dialog box appears (see Figure 1).

Figure 1. The Get External Data – Access Database dialog box.

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

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

Specify how and where you want to store the data in the current database (whether you want to import or link to the table).

Click OK. The Import Objects dialog appears (see Figure 2).

Figure 2. The Import Objects dialog box.

Select the Table tab.

Select the table from the list of tables.

Click the Options button. The Import Objects dialog appears as in Figure 3.

Figure 3. The Import Objects dialog box after selecting the Options button.

Select the desired options. Options include whether you want to import relationships, menus and toolbars, and import and export specifications. You can also designate whether you want 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.

Click OK to complete the process.