Data Type mismatch error while running Query in Excel Database

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

try removing single quote for age field ie just give 44


Now its working

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