How to import data from comma separated text file having 30 lakh rows and 19 columns into SQL Database Table

Help Studio
, , ,
1

I am trying to read data from comma separated text file having 30 lakh rows. As I am unable to add this large data into data table due to the limitations of data size. I am trying to add the data in database so that I can extract the data as per requirement. Is it possible in UiPath to bulk insert the comma separated text file data in database.

2

Please follow the below link for your scenario

https://forum.uipath.com/t/load-csv-files-into-sql/650114

3

@Ramya_25 This solution is not useful in my case as I have 30 lakh data in single text file. Data manipulation gets failed in data table.