can we update CSV file data using the query?
UPDATE MissingCustomers.csv]
SET PASS] = 'TARUNA'
WHERE PASS] = 'NA';
can we update CSV file data using the query?
UPDATE MissingCustomers.csv]
SET PASS] = 'TARUNA'
WHERE PASS] = 'NA';
Hi
Yes, you can update
UPDATE your_table_name
SET PASS = 'TARUNA'
WHERE PASS = 'NA';
Hi
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.