Teach MeShow MeLet Me TryPrint

Importing Data from Outlook

You can import data from Microsoft Outlook. This is useful for importing an address book or list of contacts.

To import data from Outlook:

  1. Click the File menu, point to Get External Data, and click Import... to open the Import dialog box.
  2. Select Outlook from the Files of type: list.
  3. The Import Exchange/Outlook Wizard will open automatically.
  4. Expand the list of Address Books and Folders to find the list that you want to import. Click the item name, then click Next.
  5. Select whether to store your data in a new table or to add it to an existing table. Click Next.
  6. If you are adding the data to an existing table, select the table from the drop-down list. Click Next to go to the last page of the wizard and finish the import.
  7. If you are creating a new table, the next page allows you to specify properties for each of the fields, such as whether to allow duplicates. You can also select a field and click the Skip Import check box to exclude the column from the import. Make your choices and click Next.
  8. You can allow Access to choose the primary key, or your can select the primary key yourself. Set the primary key option and click Next to finish the import.
  9. Give the table a name, and click Finish.

Be careful when importing to an existing table. If the column headings in the Outlook address book don't match the fields in the table, Access will report an error and you will be unable to complete the import.