Office 2010 - Access

Lesson 73: Importing data (3)

73/76 Lessons 

Importing an object from another database

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

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

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

There is a tab for each type of object. 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 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 options.

For example, in the “Import” section, the “Relationships” box is checked by default. This will be the “Relationship” between the selected tables to import. The “Menus and Toolbars” option, will ensure that the tables are imported with self-created menus and toolbars. The “Import-/export specs” option imports each “Import-/export specification” that exists in the source database.
And the “Nav Pane Groups” option will create “Navigation pane group” for each object that exists in the source database.

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

In the right part (“Query import”), default “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 opportunity to save the import steps.
Click the “Close” button.

The newly imported object is added in the “Navigation pane”.

You've completed Lesson 73