Hi Everyone, when I am trying to update in excel while connecting excel as database it is showing error update is not working select is working any help will be appreciated

Hi @bhargavi b​ ,

Good Day!

Please refer the below KB article and refer the syntax for the update statement.

https://apeople.automationanywhere.com/s/article/Excel-as-Database-Syntax-for-INSERT-and-UPDATE-queries/p>

If you are still facing an issue then please create a support case

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud/p>

if you don't have access to the above link, email the AA Support team "apeopleopsteam@automationanywhere.com" to get the access.

Thank you