Read Csv File containing 1000000 rows

[stanstilo (stanley)]

Hi Devs, please how do I read a csv file containing 1,000,000 records cause it’s throwing out of memory using read activity.
The file header is in this sample format

[Rajeswari24 (Rajeswari Punnamaraju)]

Hey!

You can refer to this thread

How to handle large CSV files in UiPath (ODBC database)

Hope this helps.

Regards,
Rajeswari

[Yoichi]

Hi,

If you use Studio 21.10 or later and your PC has enough memory, can you try to create project as Windows compatibility (not Windows-Legacy), for now?
As it works as 64 bit process, ReadCSV might work without out of memory exception.

Regards,

[stanstilo (stanley)]

Ok, I’ll try it out. Regards