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://apeople.automationanywhere.com/s/question/0D56F00008XDyLwSAL/can-i-use-csv-as-a-database?language=en_US

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

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