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

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

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 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.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base: