Skip to main content
Solved

Excel As Database DELETE SQL QUERY does not work

  • February 2, 2023
  • 4 replies
  • 1440 views

Forum|alt.badge.img

Hi All,

I am trying to delete a row based on a condition using Database Command in Automation Anywhere. Below is my code:

DELETE FROM [outstanding alert$$] WHERE [Status] = 'PB_RM Investigation';

 

I am getting error “This may be due to the following reason: - There is a syntactical error in the SQL statement. - SQL statement got timed out. “

Appreciate your help on this. Thank You.

 

 

Best answer by Narendra 5601

Hi @bahayamaricar.cantal 

Delete Query will not work when you are connecting Excel as DB. You can try with macros to get it done.

View original
Did this topic help answer your question?

4 replies

Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • February 2, 2023

Hi @bahayamaricar.cantal ,

 

Try the query without -;- symbol. 

 

 


Forum|alt.badge.img
  • Cadet | Tier 2
  • 1 reply
  • April 6, 2023

I tried removing that ; symbol still it is giving error - syntacticalsyntactical error


Forum|alt.badge.img
  • Cadet | Tier 2
  • 1 reply
  • April 13, 2023

Delete query does not work in Excel As Database


Narendra 5601
Forum|alt.badge.img+3
  • Cadet | Tier 2
  • 8 replies
  • Answer
  • April 13, 2023

Hi @bahayamaricar.cantal 

Delete Query will not work when you are connecting Excel as DB. You can try with macros to get it done.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings