ISSUE IN QUERY using OLEDB Connection

[MohiniShelke]

Hi All,
I am using OLEDB connection
Connection set successfully,
But in JOIN Query ,I ma getting error "Type mismatch"
IT is working fine for other DataTable means sheet

Connection String :"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[Data1]&";"&"Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"""

Query:"Select B.Location From [Headcount All$] A INNER JOIN [Report$] B ON A.[Employee ID]=B.[User ID]"

Error :Internal : Could not execute code stage because exception thrown by code stage: Type mismatch in expression.

Please help me to solve this.


Thanks in advance.


------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------

[david.l.morris]

Verify that the columns Employee ID and User ID are the same data type in Excel. For example, if Employee ID is Number and User ID is Text, it'll throw that Type mismatch error.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------