Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

630

When including tables, queries, forms, reports, macros, or modules — all in the same import —

you can select objects from each tab, and then import all the objects at once.

Notice also that the Import Objects dialog box includes options for importing table relationships,

menus and toolbars, and other Access database objects. Importing (and exporting, for that matter)

is an excellent way of backing up objects prior to making changes to them.

Importing an Outlook folder

An interesting Access import capability is the option to import data directly from Microsoft

Outlook. Although most people think of Outlook as an e-mail system, Outlook supports a number

of important business needs, such as scheduling and contact management.

When working with Outlook data, Access doesn’t care whether an imported item is an e-mail or

contact. Access handles all types of Outlook objects with equal ease.

Select Outlook Folder from the More drop-down list in the Import group to open the initial Outlook

Folder import dialog box (shown in Figure 17.24). Access provides options for importing Outlook

data, adding it to an existing Access table, or linking to it from the current Access database.

FIGURE 17.24

The initial Outlook import options