Database querry for CSV

Hi @Prashant M ,

Yes, you can update

UPDATE your_table_name
SET PASS = 'TARUNA'
WHERE PASS = 'NA';
 

Hi @Prashant M 

Were you able to solve this? I think this gives syntactical error even though the query is correct.

I am trying to insert new data into a csv file using database actions but getting syntax error,

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

Any help would be appreciated!