Skip to main content
We are trying to connect to CSV as a Database and could successfully select desired records using Microsoft Text Driver. However unable to Update records. Any help with Update SQL Statement to update CSV as a DB would be much appreciated

Hi @Rajiv Tarafdar​ ,

 

checkout below link for resolution,

 

https://apeople.automationanywhere.com/s/question/0D52t00001DpGRNCA3/i-c-onnected-csv-file-using-microsoft-text-connection-string-in-a360-using-database-insertupdate-command-i-tried-to-update-the-csv-file-but-it-is-showing-syntactical-error?s1oid=00D90000000gDTdamp;OpenCommentForEdit=1&s1nid=0DB6F000000oMPS&emkind=chatterPostNotification&s1uid=0056F00000ATXY5&emtm=1644922105579&fromEmail=1&s1ext=0


Hi @Rajiv Tarafdar​ ,

 

You can't update records in CSV unless it involves a JOIN operation.

Here is the syntax for updating records in CSV using JOINs:

 

UPDATE Movies$$] AS t1

INNER JOIN

ON t1.>Title]=t2.]Title]

SET t1.>Title]= t2.=Profit]

 

I haven't tried using Self Joins, maybe try giving that a try and see if it works out for you?

 

Kind Regards,

Ashwin A.K


Reply