OL2000: How to Store Outlook Items in an MS Access Database

ID: Q196865

The information in this article applies to:
  • Microsoft Outlook 2000
  • Microsoft Access 2000

SUMMARY

This article describes how to store various Microsoft Outlook 2000 items in a Microsoft Access 2000 database file.


MORE INFORMATION

In order to store Outlook items (for instance, Contacts) in a Microsoft Access table, follow these steps:

  1. Start Microsoft Access and under Create a new database using, click Blank Access Database and click OK.

    -or-

    With Microsoft Access running, click Open on the File menu.


  2. In the File Name box, type a file name, such as Contacts, and then click Create.


  3. Click Create table by entering data, and then click Open.


  4. On the File menu, point to Get External Data and click Import.


  5. In the Files Of Type list, click Outlook.


  6. In the Import Exchange/Outlook Wizard dialog box, click to select your Contacts folder, and then click Finish and OK.


NOTE: This procedure imports all fields from the Outlook item. If you want to select only certain fields, you can click Next instead of Finish in step 5, and then follow the instructions in the Import Wizard.

Additional query words: OL2K

Keywords : kbinterop kbconversion IntpOff
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto


Last Reviewed: October 12, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.