Skip to main content
Question

Insert/update data in a CSV file using database actions


Forum|alt.badge.img+1

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.

2 replies

jon.stueveapeople
Automation Anywhere Team
Forum|alt.badge.img+7

How are you setting up the Database connection string?


Forum|alt.badge.img

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


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