Data Type mismatch error while running Query in Excel Database

Help Activities
, ,
1

I got
Run query: ERROR [22018] [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.

While i was executing the excel database workflow.
The Query inside the “Run query” activity is
“select [Name] from [sheet1$] where [Age]=‘44’”

3

try removing single quote for age field ie just give 44

Regards

4

Now its working
Thanks

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.