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], , [PasswordAdapter]) VALUES ('$recSNOWData[0]$', '$recSNOWData[2]$', 'PasswordAdapter1');Any help would be greatly appreciated.

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 ('$recSNOWDataa0]$', '$recSNOWDataa2]$', 'PasswordAdapter1');

Any help would be greatly appreciated.

Page 1 / 1

How are you setting up the Database connection string?

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