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