Insert/update data in a CSV file using database actions

I am trying to insert/delete data in/from a CSV file using database actions but getting syntactical error,

INSERT INTO [WBSApprover_20210712.csv] ([PUPlant], [User], [PasswordAdapter]) VALUES ('$recSNOWData[0]$', '$recSNOWData[2]$', 'PasswordAdapter1');

Any help would be greatly appreciated.

This topic has been closed for replies.

Best answer by mamoonmanzoor

Unfortunately, CSV files are static and cannot be updated.
You must either write the data to Excel and update it there

Automation Anywhere Team

How are you setting up the Database connection string?

Cadet | Tier 2

Unfortunately, CSV files are static and cannot be updated.
You must either write the data to Excel and update it there

Sign up