Solved

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.

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

This topic has been closed for replies.

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

Sign up