With a large file, it's better to read it in 'chunks' by using a StreamReader and buffering the data
Have a look at this article, which shows the technique (c#)
A Fast CSV Reader[
^]
There isn't going to be a maximum file size per se, you will be limited by the resources available on the machine running the code.