Question

Database querry for CSV

+2

can we update CSV file data using the query?

UPDATE [MissingCustomers.csv]

SET [PASS] = 'TARUNA'

WHERE [PASS] = 'NA';

Userlevel 6

+15

Hi @Prashant M ,

Yes, you can update

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

Userlevel 3

+7

Hi @Prashant M

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

+1

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!

Sign up