Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.

This article was previously published under Q196865

↑ Back to the top


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

↑ Back to the top

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.


    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 ony imports default standard Outlook fields; custom or user defined fields are not imported. If you want to select only certain fields, you can click Next instead of Finish, in step 5, and then follow the instruction in the Import Wizard.

↑ Back to the top


For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
197654� OL2000: Cannot Import or Export User-defined Outlook Fields

↑ Back to the top

Keywords: KB196865, kbusage, kbmigrate, kbimport, kbexport, kbhowto

↑ Back to the top

Article Info
Article ID : 196865
Revision : 3
Created on : 7/13/2004
Published on : 7/13/2004
Exists online : False
Views : 422