首先要更新64位的驱动,如果系统有装32位office,就会不行。
如果是64位裸机,或者64位office的话,就没问题
需要安装
http://www.microsoft.com/ja-jp/download/details.aspx?id=13255
\Microsoft.ACE.OLEDB.12.0
例子
public static DataTable ReadCSV(string filePath, string fileName)
{
DataTable dt = new DataTable();
string cnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + filePath + ";" +
"Extended Properties=Text";
using (OleDbConnection cn = new OleDbConnection(cnStr))
{
OleDbDataAdapter ad = new OleDbDataAdapter("SELECT * FROM " + fileName, cn);
try
{
ad.Fill(dt);
}
catch (Exception ex)
{
dt = new DataTable();
}
}
return dt;