Resolving Microsoft Jet Error 'Unknown'

Product(s): Tableau Desktop
Version(s): All
Last Modified Date: 15 Jul 2014

Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.

When you drag a dimension or measure to a workbook view that has a live connection to a Microsoft Excel data source from Tableau Desktop, you might see the following error:

Microsoft JET database error 0x80040E14: Unknown

Excel is built on the Microsoft Jet database engine. This error message appears because one of the three Jet drivers that Excel uses to connect to Tableau is out-of-date or corrupted. To resolve this issue, follow the steps in one of the options listed below. 

Option 1: Uninstall existing driver and install new driver

This option requires you to uninstall the Microsoft Access Database Engine 2007 driver and install the Microsoft Access Database 2010 Redistributable driver.

Step 1

On the computer running Tableau Desktop, uninstall the Microsoft Access Database Engine 2007 driver.

Step 2

Download and install the 32-bit Microsoft Access Database Engine 2010 Redistributable driver from the Microsoft Download Center website.

Note: Alternatively, installing the Microsoft Access 2013 Runtime driver should also resolve this issue.

Option 2: Re-register the Microsoft Jet data engine

Step 1

On the computer running Tableau Desktop, click the Windows Start button.

Step 2

In the search box, type Command Prompt, and in the list of results, click Command Prompt.

Step 3

Type the following command:  regsvr32.exe C:\Windows\system32\msjtes40.dll.

When the command is complete, a message appears to indicate the success of the operation.

Step 4

Restart the computer, open Tableau Desktop, and then perform the action that previously caused the Jet database error.

Step 6

If the error persists, open the command prompt again, and run the following commands:

  • regsvr32.exe C:\Windows\system32\msjetoledb40.dll
  • regsvr32.exe C:\Windows\system32\msjet40.dll

For information about other possible causes of the Jet error Unknown, see the Related Articles list.

Alternate Search Terms:data sources, 0x80040e14 dragging, drag, dimension, excel, measure, microsoft, jet
Did this article resolve the issue?