Unable to read CSV file having > 2 GB Data

Dear @ppr and @supermanPunch
I tried the second approach as well, and still the same error.

but this code worked

Blockquote

Using r As StreamReader = New StreamReader(filePath)
While Not r.EndOfStream
Console.WriteLine(r.ReadLine)
End While
End Using

Blockquote

or

Blockquote

Using r As StreamReader = New StreamReader(filePath)
While Not r.EndOfStream
inCounter+=1
‘Console.WriteLine(r.ReadLine)’
End While
End Using

Blockquote

but kindly tell me how to add it to the data table and apply filters on it .
@ppr @supermanPunch

Lines  = New List(Of String)()
Using r As StreamReader = New StreamReader(strFilePath)
  Do While ( Not r.EndOfStream)
  Loop
End Using

can you check the run without adding the line to the list. So we isolate more the failure? Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.