Excel Connection Issues

Issue: Error occurs when connecting to Excel file

Symptoms:

Resolution:

  1. Install the 64-bit Microsoft Access Database Engine 2010 on the server.
  2. If, for some reason, you need to install the 32-bit Access driver instead, you can run your IIS or application pool in 32-bit mode, so that the 32-bit drivers will function correctly with Dundas BI. See Run IIS in 32 bit mode for more details.
  3. For testing (non-production use) only: If your machine is running Windows 64-bit and you have Office 32-bit installed, you can force the 64-bit Access driver to install by running the installer with the following command: AccessDatabaseEngine_x64.exe /passive

See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri