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

Help Activities
, ,
1

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

1 Like
3

Hi @srujana13a5

Check with the reference link below!

Regards

4

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
5

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.

image
image1896×715 68.6 KB

Regards
Balamurugan.S

2 Likes