KNOWLEDGE BASE

Microsoft Jet Driver Error 'Unknown'


Published: 29 Mar 2017
Last Modified Date: 23 Aug 2019

Issue

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

Microsoft JET database error 0x80040E14: Unknown

Environment

  • Tableau Desktop earlier than 2019.1 (See note in Additional Information)

Resolution

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 missing or corrupted. To resolve this issue, follow the steps listed below. 
  1. Reconnect to your Excel data source by going to the Data tap and choose New Data Source.
  2. In the Data tap that opens, select To a File > Excel
  3. The Open dialog box opens and you navigate to your Excel file.
  4. In the Open drop-down menu, choose Open with Legacy Connection


User-added image

     5. You have now connected your Excel file using the correct Microsoft Jet data engine drivers and a new Data Source window opens.

As an added feature, the Legacy Connection has the option of extracting a data set by writing a Custom SQL Query.

Cause

 

 

Additional Information

Note: Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection.



Discuss this article... Feedback Forum
Did this article resolve the issue?