ISSUE IN QUERY using OLEDB Connection

MohiniShelke — Thu, 25 Jul 2019 08:20:00 GMT

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
------------------------------

RE: ISSUE IN QUERY using OLEDB Connection

david.l.morris — Thu, 25 Jul 2019 11:26:00 GMT

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
------------------------------

topic ISSUE IN QUERY using OLEDB Connection in Product Forum

ISSUE IN QUERY using OLEDB Connection

RE: ISSUE IN QUERY using OLEDB Connection