Parsing CSV files in .net

There are numerous ways to read CSV files in .net, using ODBC, using Jet OLED, and then hand-crafting a solution using string.Split (which is almost always the worst way to do things). Not to mention a multitude of  home-grown solutions on codeproject.com and the like. None of which seem to handle every case.

One that seems to receive very little press is the TextFieldParser in the Microsoft.VisualBasic.IO namespace. Quite why this got "relegated" to what is effectively the modern-day MSVBVMxx.DLL, I have no idea as it's bloody useful. Yes. Bloody useful!