public static DataTable GetDataTableFromText(Stream stream, string seperator, Encoding encoding) {
  DataTable dt = new DataTable();
  using (StreamReader sr = new StreamReader(stream, encoding)) {
    string strLine = sr.ReadLine();
    string[] strArray = strLine.Split(seperator);

    //dt.ExtendedProperties.Add("HeadLine_CheckSum", strLine.GetMD5Hash());

    if (strLine.Contains(seperator.ToString())) {
      foreach (string value in strArray) {
        DataColumn nC = new DataColumn(value.Trim() + System.Guid.NewGuid().ToString());
        nC.Caption = value.Trim();
        dt.Columns.Add(nC);
      }

      DataRow dr = dt.NewRow();
      while (sr.Peek() > -1) {
        strLine = sr.ReadLine();
        if (strLine.Trim() != "" && strLine.Contains(seperator.ToString())) {
          strArray = strLine.Split(seperator);
          dt.Rows.Add(strArray);
        }
      }
    }

  }
  return dt;
}

//Importieren der Datei "test.csv" mit UTF8-Zeichencodierung die ein Semikolon als Trennern verwendet
DataTable dtSource = ImporterHelper.GetDataTableFromText(new FileStream(@"c:\test.csv", FileMode.Open), ";", Encoding.UTF8);
foreach (DataRow row in dtSource.Rows) {
  //dein Code
}

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Folder\;Extended Properties='text;HDR=Yes;FMT=Delimited';"

"Select * From File.csv"

"A,""B"",""C"",""D"""

 public IEnumerable<string[]> GetAllRows()
        {
            string[]rows = System.IO.File.ReadAllLines(File.FullName);
            foreach (var row in rows)
            {
                yield return parser.Parse(row);
            }
        }


       public string[] Parse(string text)
        {
            const string mySeparator ="|::|";
            const string firstSeparator = "\"\",\"\"";
            const string secondSeparator = ",\"\"";

            var parsedText = text.Trim('"');
            parsedText = parsedText.Replace(firstSeparator , mySeparator);
            parsedText = parsedText.Replace(secondSeparator , mySeparator);
            return parsedText.Split(new[] { mySeparator }, StringSplitOptions.None);
        }