Why am I receiving the error message "*** Error: (42000) [Microsoft][ODBC Excel Driver] Invalid SQL statement" when using the DB Tester functions against Excel?
If you are receiving the "*** Error: (42000) [Microsoft][ODBC Excel Driver] Invalid SQL statement; expected "DELETE", "INSERT", "PROCEDURE", "SELECT", or "UPDATE"." error message when using the SilkTest DB Tester functions against an Excel worksheet as shown below:
The reason for this is because you are attempting to run an SQL Statement that it not supported by the Microsoft ODBC Driver when working with Excel. The supported SQL statements are described in solution Which SQL statements are supported by SilkTest DB_Tester?.