You cannot import data to an Access database project from an Exchange File or an Outlook File (828410)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Office Outlook 2003
This article applies only to a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

If you are working with a Microsoft Office Access 2003 database project, and you try to import data from a Microsoft Exchange file or a Microsoft Outlook (.pst) file on a computer where Microsoft Office Outlook 2003 is installed, the data may not be imported successfully. You may receive the following error message (where <folder name> is the name of the Outlook data folder or the Exchange data folder that was used in the import process):
An error occurred trying to import file '<folder name>'. The file was not imported.

WORKAROUND

To work around the problem, import the data from the Exchange file or from the Outlook file to an Access database file (.mdb), and then import the data from the Access database file to the Access database project. To do so, follow these steps.

Caution If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
  1. Start Access 2003.
  2. Open the Northwind.mdb sample database.
  3. On the File menu, point to Get External Data, and then click Import.
  4. In the Import dialog box, in the Files of type list, click either Exchange() or Outlook().
  5. In the Import Exchange/Outlook Wizard dialog box, locate and then click the appropriate Exchange or Outlook data folder.
  6. Click Finish.
  7. Click OK.
  8. Close the Northwind sample database.
  9. Open your Access database project.
  10. On the File menu, point to Get External Data, and then click Import.
  11. In the Import dialog box, in the Files of type list, click Microsoft Office Access (*.mdb;*.adp;*.mda;*.mde;*.ade).
  12. Locate and then click the Northwind.mdb file that you opened in step 2, and then click Import.
  13. In the Import Objects dialog box, click the Tables tab, click to select the table that is imported in step 6, and then click OK.
The data from the Exchange file or the Outlook file is successfully imported to the Access database project.

MORE INFORMATION

The problem only occurs on computers where Outlook 2003 is installed. However, you can import the data successfully from Outlook or Exchange files to an Access database, even if Outlook 2003 is installed on the computer. You can also import data from Outlook or Exchange files to Access databases and Access projects on computers where earlier versions of Outlook are installed.

Steps to Reproduce the Problem

Caution If you follow the steps in this example, you modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and follow these steps on a copy of the project.
  1. Start Access.
  2. Open the sample Access database project named NorthwindCS.adp.
  3. On the File menu, point to Get External Data, and then click Import.
  4. In the Import dialog box, in the Files of type list, click either Exchange() or Outlook().
  5. In the Import Exchange/Outlook Wizard dialog box, expand Personal Folders, and then click Inbox.
  6. Click Finish.

    You receive the error message that is mentioned in "Symptoms" section of this article. After you click OK, the data is not imported to the Access database project.

REFERENCES

For more information about how to open an Access database project, click Microsoft Access Help on the Help menu, type open an Access project in the Search for box in the Assistance pane, and then click Start searching to view the topic.
Modification Type:MinorLast Reviewed:6/8/2004
Keywords:kbOutlookObj kbImport kbADP kberrmsg kbprb KB828410 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.