Here is the command i used to update :
UPDATE [Tender Details.csv] SET [Status] = 'Yes' WHERE [Previous Row Number] = '45617284'
I c onnected csv file using microsoft text connection string. In A360 using database insert/Update command i tried to update the csv file but it is showing "Syntactical error".
Userlevel 4
+8
Please checkout below connection string,
DB Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Path of CSV;Extended Properties="text;HDR=Yes;FMT=Delimited";
https://www.connectionstrings.com/textfile/
Sample - Connection string - DSN=Csv;DBQ=C:\USERS\UserProfile\DESKTOP;DefaultDir=C:\USERS\UserProfilr\DESKTOP;DriverId=27;FIL=csv;MaxBufferSize=2048;PageTimeout=5;
Refer old thread on the same - https://apeople.automationanywhere.com/s/question/0D56F000086EHFzSAO/csv-file-as-a-database
Userlevel 3
+7
Hi @Kishore Kaveti Venugopal ,
I'm afraid that is not possible.
I've cracked my head over this one and was only able to Update CSVs where the operation included JOINs.
Here is an article I've penned on the subject, I hope you find it resourceful.
Kind Regards,
Ashwin A.K
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.