You cannot select your Excel data file or you receive an error message when you try to import data into Autoroute, MapPoint, or Streets & Trips by using the Data Import Wizard

When you try to import data into Microsoft Autoroute, into Microsoft MapPoint, or into Microsoft Street & Trips by using the Data Import Wizard, you experience one or more of the following symptoms:

• You cannot select your Excel data file.
• You receive the following error message:
  There is a problem opening this file filename. The file is not in the expected format.
  Note In this error message, filename is the name of the file that the Data Import Wizard is trying to import.
• Although the file is imported, and you can follow the prompts in the Data Import Wizard, the Finish button in the wizard is unavailable.

This problem occurs if one of the following conditions is true:

• You are using Excel 2007 or a later version, and your data file is saved in the .xlsx or .xlsm format.
  
  Note Both Streets & Trips and MapPoint 2009 support the .xlsx format. However, these programs do not support macro-enabled workbooks that have the .xlsm file name extension.
• The file that the Data Import Wizard is trying to import is damaged.
• Microsoft Data Access Components (MDAC) is missing or is damaged.
• The file that the Data Import Wizard is trying to import is locked or is being used by another program or by another user.
• You were not logged on as an administrator during the installation process.
• The file name is longer than 63 characters.

Additionally, you may receive the error message if the following conditions are true:

• You are trying to link to a Microsoft Access query.
• The query is running from a linked table in the same database.
• The linked table is accessing a table inside a different Access database.

To resolve this problem, export the query to the database that contains the original table that you tried to import as data. The query and the table must be in the same database to establish the link to the query.

If this procedure does not resolve the problem, use the following methods in the order in which they are presented. If you still experience the problem after you use the first method, go to the second method.

Note Before you use these methods, make sure that no other programs are using the source file, make sure that these programs are closed, and make sure that no other users have opened the file that you want to import.

Method 1: Install Access Database Engine

1. Insert the Streets & Trips or MapPoint DVD in the DVD drive.
2. Click Start, click My Computer, and then browse to the following location (as appropriate for your program):
   <drive>:\MapPoint\MSMap\Redist\ADE
   <drive>:\ Streets\MSMap\Redist\ADE

   Note <drive> is the disc drive that contains the product installation DVD.
3. Double-click AccessDatabaseEngine.exe, and then follow the instructions on your screen. Reboot the computer if you are if prompted.

Or, to access an online installation point for Access Database Engine, visit the following Microsoft Web site:

Method 2: Manually register the MDAC files

To do this, follow these steps:

1. Close all open windows.
2. Click Start, and then click Run.
3. In the Open box, type the following command, and then press ENTER:
   cmd
4. At the command prompt, type the following commands. Press ENTER after each command:
   • regsvr32.exe Msexcl40.dll
   • regsvr32.exe Msexch40.dll
   • regsvr32.exe Msrd2x40.dll
   • regsvr32.exe Msrd3x40.dll
   • regsvr32.exe Msltus40.dll
   • regsvr32.exe Mspbde40.dll
   • regsvr32.exe Mstext40.dll
   • regsvr32.exe Msxbde40.dll
5. Start Autoroute, MapPoint, or Streets & Trips, and then try to import files again.

Method 3: Make sure that you have the latest version of MDAC

To do this, follow these steps.

Step 1: Determine which version of MDAC is installed

To do this, follow these steps.

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

1. Close all open programs.
2. Click Start, and then click Run.
3. In the Open box, type the following command, and then press ENTER:
   regedit.exe
4. Locate and then click the following key in the registry:
   HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
5. Click DataAccess, and then locate the FullInstallVer value in the Details pane.
6. In the Data column, examine the version number for the DataAccess value. If the version number for this value does not resemble the following version number, you do not have the most current version of MDAC:
   2.8#.####.#
   Note In this version number, # is a number between 0 and 9, inclusive.
7. Exit Registry Editor.
8. If you do not have the latest version of MDAC, go to "Step 2: Install the latest version of MDAC."

Step 2: Install the latest version of MDAC

To do this, follow these steps:

1. Visit the following Microsoft Web site:
   http://www.microsoft.com/downloads (http://www.microsoft.com/downloads)
2. Under Search for a Download, type mdac in the Keywords box, and then click Go.
3. In the list of found download files, click the MDAC 2.8 link.
4. Click Download, and then click Save.
5. In the Save in box, click Desktop, and then click Save.
6. On the Windows desktop, double-click the Mdac_typ.exe file.
7. Follow the instructions to install the MDAC 2.8 Update.
8. Restart the computer when you are prompted.

If you have problems while you are installing the MDAC 2.8 Update, restart the computer in safe mode, and then repeat these steps.

To restart the computer in safe mode, follow these steps:

1. Press and hold the CTRL key when you see the "Starting Windows" message.
2. On the Startup menu, click Safe Mode.

MDAC enables Autoroute, MapPoint, and Streets & Trips to import files from other applications such as Microsoft Excel.

For more information about how to determine what version of MDAC is installed, click the following article number to view the article in the Microsoft Knowledge Base:

Method 4: Use MDAC Components Checker

To determine whether the MDAC components are installed correctly, to diagnose problems with MDAC, or to diagnose other problems, you can install and use MDAC Component Checker.

For more information about Component Checker, click the following article number to view the article in the Microsoft Knowledge Base: