KNOWLEDGE BASE

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


Published: 18 Dec 2015
Last Modified Date: 20 Jun 2017

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
  • 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. 
 
Did this article resolve the issue?