KNOWLEDGE BASE

Error "Database Error 0x80004005: Type mismatch in expression" Creating Table Join


Published: 18 Dec 2015
Last Modified Date: 21 Apr 2019

Issue

When you try to create a join using a file-based data source such as Microsoft Excel, the following error occurs: 

“Database error 0x80004005: Type mismatch in expression”

Environment

  • Tableau Desktop earlier than 2019.1 (see note in Additional Information)
  • Legacy Connection to Microsoft Excel 

Cause

The columns used in the join are not all the same data type.

Additional Information

In Legacy connections, the Microsoft JET Database Engine is responsible for determining the data types for each column in your data source.

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?