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

Published: 18 Dec 2015
Last Modified Date: 18 Dec 2015


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”


  • Tableau Desktop
  • Legacy Connection to Microsoft Excel 


Option 1: 

Upgrade your data source. For more information, see Upgrading Data Sources

Option 2: 

Ensure that the columns used in the join are all the same data type. For more information, see the suggestions in Resolving Incorrect Data Type Issues


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?