Microsoft Access 2010 Bible

Chapter 17: Importing and Exporting Data

631

Selecting the import option opens the Import Exchange/Outlook Wizard (shown in Figure 17.25).

As shown in this dialog box, Access can import Outlook e-mail, contacts, calendars, journals, and

other folders.

FIGURE 17.25

Importing Outlook objects into Access

Depending on which item you select in the Import Exchange/Outlook Wizard, the remaining wiz-

ard screens walk you through the process of bringing Outlook data into Access. You can import

Outlook data into a new or existing table, add a primary key, specify data types, and save the

import process for later execution.

Importing dBase tables

dBase (currently a product of dataBased Intelligence, Inc.) has been around for many years.

Although dBase’s popularity has faded over time, because of its simplicity, the dBase format is used

by many different applications (for example, Microsoft FoxPro). Access continues to support dBase

import and export processes for developers needing access to these data sources.

dBase files can be imported directly into Access tables. The native dBase data types are converted

to Access equivalents during the conversion.

You can import any dBASE III, dBASE IV, or dBASE 5 database table into Access. When browsing

to the dBase file, select the correct dBase version in the Files of Type box in the lower-right corner

of the File Open dialog box (shown in Figure 17.26).