Good afternoon All,
I have an issue where I can query my Excel table as DB by implementing the OLEDB driver. I can query using the hard-coded string. But unfortunately can not query using the variable in my String as I need to pass variables from another workflow to look up for a data in my excel sheet.
"SELECT [First], [Middle], [Last] FROM [SAM_Exclusions_Public_Extract_1$] WHERE [First] = “+firstName+”[Middle] = “+middleName+”[Last] = “+lastName+”;"
This is how my query looks like where firstName, middleName and last Name are variables. Any help in resolving this issue is appreciated.
Below is the error message I get when executing the query: