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

Published: 18 Dec 2015
Last Modified Date: 05 Oct 2018


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 


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?