Hi,
In Tosca 2025 version i am unable to read data from excel using db modules, same script/syntax was working in 2023.
getting below error:
ERROR [42000] [Microsoft][ODBC Excel Driver] 'Sheet1 is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Could not execute the following SQL statement:
Select * from [Sheet1$] WHERE [TCID]='TC07'
Select * from [Sheet1$] WHERE [TCID]='TC07' AND [NAME]=’Nitin’
both the queries throwing error in execution list.
Note: I am facing issue to execute at execution list level only, at test step or folder level its working, i mean scrachbook its working fine.