Importing an object from another database

In “Access” 2007, we have the option of importing any object from another database.
Just click “Access” in the “Import” group under the “External Data” tab in the “Ribbon”.

This opens a dialog where you select which database objects you want to import by clicking the “Browse” button.

Click the OK button.
This opens the “Import Objects” dialog box.

For each type of object, there is a tab.

To select an object, click the object.
To select multiple objects click all the items you want to import.

If you wish to remove the selection of objects or a selected object, click the object again.

To select all objects from the list, click the “Select all” button.
In order to remove all selections, click the “Deselect All” button.

To import objects from different tabs, select the tab and click the object. The selected objects under the other tabs remain selected.

Clicking the “Options” button gives us some additional option settings.

For example, in the “Import” section, the “Relationships” box is checked by default.
This is the relationship between the selected tables within the import.

The “Menus and Toolbars” option, will then ensure that self-created menus and toolbars are created with import.

The “Import-/Export Specifications” option ensures that each import-/export specification that exists in the source database is also imported.
And the “Navigation Pane Groups” will create each navigation group that exists in the source database.

In the middle part (“import Tables”), we have the choice between “Definition and data” or “Definition only”
When you choose “Definition Only” the records from the table are not imported, only the structure is imported.

In the right part (“Import Queries”), default is “As queries” is checked.
This will import the queries as queries, the second option will import them “As tables”.
Do not forget to import all the underlying tables when you import a query.

Click the OK button when you’re done.

In the next window, we have the option to save the import steps.
Click the “Close” button.

The newly imported objects are added to the “Navigation panel”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats