Microsoft KB Archive/828410

= You cannot import data to an Access database project from an Exchange File or an Outlook File =

Article ID: 828410

Article Last Modified on 6/8/2004

-

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  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 ' '. 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 &quot;Symptoms&quot; section of this article. After you click OK, the data is not imported to the Access database project.

