[code]
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("’", "”");

}
}
}
}
[/code]

characterset=65001はUTF8