using System.Data; using (var connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" + @"CSVのあるフォルダ" + "\";Extended Properties='text;characterset=65001;HDR=Yes;FMT=Delimited(,)';")) { using (var command = new OleDbCommand("SELECT * FROM [ファイル名]", connection)) { connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { // 数値項目 string no = reader.GetInt32(1).ToString(); // 文字列項目 string name = reader.GetString(0).Replace("'", "''"); } } } }
characterset=65001はUTF8