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

How to handle huge CSV files using UiPath.

0:00 Intro
0:20 The purpose of the movie
0:40 Excel limitation
2:00 How I generate the testing files
3:05 The goals of the process
3:35 The approach with UiPath activities
5:00 The RAW approach with removing row with if conditions
10:40 Try to read files as a text
14:00 Approach with Database ODBC connection
17:30 Difference between multiple approaches
20:00 Particular characters in a different language
20:45 Conclusions
21:30 Subscribe to my channel

2 Likes

You’ve got a good habit of coming up with the video on the weird business problem I’m working on @Cristian_Negulescu

Just a trap I ran into with the Microsoft CSV ODBC Connection - it can’t deal with two “.”''s in a file name. E.g. if your csv happened to be called:

dbo.t011_licences.csv

You get an error message saying “The Microsoft Jet database engine could not find the object”

Works fine if you just get down to a single .

Thanks again.

1 Like