Solution to Read Large CSV Files (>= 1 GB)

Here is the Stream Reader Code with which you can read any Large CSV Files (>=1 GB)
Reading_CSV_2gb.xaml (55.2 KB)

Blockquote

Lines = New List(Of String)()
Using r As StreamReader = New StreamReader(filePath)
While Not r.EndOfStream
If inCounter<100000 Then
Console.WriteLine(r.ReadLine)
Lines.Add(r.ReadLine())
Else
Exit While
End If
inCounter+=1
End While
End Using

Blockquote

1 Like

Hi @Nissy_Ruth_Prabhu ,
useful!
happy automation