when I am Using this query in Execute Non Query Activity
“Update [Sheet1$] Set Salary=‘23000’ Where Name=‘Nisarg’”
I am Facing an issue
Execute Non Query: ERROR [HY000] [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
Please any one help me
Thanks in advance
Check with the reference link below!
I have just checked and the code is already running the latest version of the database activities
By default MS Access DB will allow us to read only mode so we cannot execute update Queries. this error mainly occurs due to you have only read only mode.
If possible please change to read only mode to Read and write mode so that you will be able to update the data in excel via MS access DB with ODBC excel connector. thanks.
@srujana13a5 and @kirankumar.mahanthi1 ,
Here is an enterprise package for only excel. It has database execution activities that have been made for only excel.