AccessDatabaseEngine.exe自然是要装的,但是关键是Provider=Microsoft.Jet.Oledb.4.0一定要替换成Provider=Microsoft.ACE.OLEDB.12.0因为其中的Jet和ACE很相似但是却很容易忽略,这个是我的代码:
ResultInfo<List<HighEndNetFinancialEntity>> Result = new ResultInfo<List<HighEndNetFinancialEntity>>();
string ver = "";
int pos = FilePath.LastIndexOf(".") + 1;
string postFileName = FilePath.Substring(pos, FilePath.Length - pos);
if (postFileName == "xls")
{
ver = "8.0";
}
else if (postFileName == "xlsx")
{
ver = "12.0";
}
else
{
Result.Message = "请上传Exel-xls文件。";
Result.IsSuccess = false;
return Result;
}