NOTICE: Our Community is moving. Get more information.
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?.