Error in Excel as Database execute Non-Query: Update query

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

Hi @srujana13a5

Check with the reference link below!

Regards

Hi,

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.

1 Like

HI @srujana13a5 and @kirankumar.mahanthi1 ,

Here is an enterprise package for only excel. It has database execution activities that have been made for only excel.

Regards
Balamurugan.S

2 Likes