• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 7. Linking, Importing, and Expor... > Exporting and Importing Jet 4.0 Tabl...

Exporting and Importing Jet 4.0 Tables with Outlook

To import an Access table to an Outlook 2000 contacts folder, do the following:

  1. Open Outlook and select the folder to which you want to import. (Create a new empty Contacts subfolder when you are testing import and export operations.)

  2. Choose File, Import and Export to open the Import and Export Wizard. Select Import from Another File or Program in the Choose an Action to Perform list (see Figure 7.30), and click Next.

  3. Select Microsoft Access in the Import a File dialog (see Figure 7.31), and click Next.

    Figure 7.30. Selecting the file option operation in the first Outlook Import and Export Wizard dialog.

    Figure 7.31. Specifying Microsoft Access as the import file type.

  4. Click Browse to open the Browse dialog, and then navigate to and select the .mdb file that contains the table you want to import. This example uses Northwind.mdb's Customers table. Select an option for handling duplicates, and then click Next (see Figure 7.32).

    Figure 7.32. Specifying the .mdb file and handling of duplicate records.


    Make sure the.mdb file from which you intend to import the data is closed at this point. If the .mdb file is open, you receive an error message when you attempt to complete the next step.

  5. The destination folder you specified or added in step 1 is selected in the Import a File dialog (see Figure 7.33). If you didn't select a folder, you must do so at this point. Click Next.

    Figure 7.33. Confirming the destination folder for the imported records.

  6. Mark the Import TableName into the FolderName option for the table to import, Customers for this example.

  7. Click Map Custom Fields to open the Map Custom Fields dialog, and drag from the left list the fields you want to include in the Contacts list to the appropriate Outlook field name in the right list (see Figure 7.34). Fields that you don't drag to the right list aren't included in the new Contacts folder.

    Figure 7.34. Mapping table fields to the Outlook standard Contacts fields.

  8. Click OK to close the Map Custom Fields dialog; then click Finish to close the Import File dialog and complete the import process. When the records are imported, Outlook automatically displays them (see Figure 7.35).



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint