I am tryin to update an excel with the help of update query using db_execute_query command by im gettin -10162 error in return... pls let me know any prblm in the approach..
sTableName = "Sheet1";
sQuery = "UPDATE [" & sTableName & "$] SET Col2 = '1' WHERE Col1 = 'A'";
irc = db_execute_query(g_sDATATABLE_SESSION,sQuery,iRowC nt);
.... note: select query is workin as expected... prblm is with only update statement
you can't use db-* functions to update an excel sheet. THey are for a true database.
Go into the TSL help information and research the ddt_* functions
Insanity: doing the same thing over and over again and expecting different results
There is an Excel ODBC driver.
Are you able to execute a select statement viki?
Are you able to execute that statement outside WR?
(Gee its nice to see some action in WR).