Excel As Database DELETE SQL QUERY does not work

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.

Premier Pathfinder | Tier 7

Hi @bahayamaricar.cantal ,

Try the query without -;- symbol.

Padmakumar

Cadet | Tier 2

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

Cadet | Tier 2

Delete query does not work in Excel As Database

Navigator | Tier 3

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

Sign up