Skip to main content

can we update CSV file data using the query?

 

UPDATE MissingCustomers.csv]

SET PASS] = 'TARUNA'

WHERE PASS] = 'NA';

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!


Reply