Part III: More-Advanced Access Techniques
612
- Click the External Data tab.
- Click the Access option in the Import section, and then click on the Browse button to
select the filename of the source database (Chapter17_2.accdb).
The Import Objects dialog box (shown in Figure 17.2) appears. It gives you options for
importing a database object.
Note
When working with an external Access database, you can import any type of object, including tables, queries,
forms, reports, macros, and VBA code modules.
FIGURE 17.2
Many types of Access database objects can be imported from one Access database into
another.- Select a table, and click OK.
If an object already exists in the destination database, then a sequential number is added
to the name of the imported object, distinguishing it from the original item. For example,
if tblDepartments already exists, the new imported table is named tblDepart-
ments1.
The Get External Data – Save Import Steps dialog box appears, with a very useful feature
that allows you to store the import process as a saved import, as shown in Figure 17.3.
- Provide a name for the import process to make it easy to recall the saved import’s purpose.
You can execute the saved import again at a later date by clicking the Saved Imports but-
ton in the Import group of the External Data ribbon tab (see Figure 17.4).