Question

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

  • 4 August 2022
  • 1 reply
  • 14 views

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

1 reply

Userlevel 4
Badge +8

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

Reply