Skip to main content
Solved

Excel As Database DELETE SQL QUERY does not work

  • February 2, 2023
  • 4 replies
  • 1440 views
B
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
    • Padmakumar
    • Navigator | Tier 3
    • 785 replies
    • February 2, 2023

    Hi @bahayamaricar.cantal ,

     

    Try the query without -;- symbol. 

     

     

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

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

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

    Delete query does not work in Excel As Database

    Narendra 5601
    Forum|alt.badge.img+3
    • Narendra 5601
    • 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.

    Narendra Guptha

    Reply


    Terms & ConditionsCookie settings

    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