导入Excel文件:Could not find installable ISAM
原因
1.连接字符串格式错误
如:Data Source 写成DataSource,Extended Properties 写成 ExtendedProperties,中间要有空格!
参考:
Office 2007
Provider=Microsoft.ACE.OLEDB.12.0;Data Source={_FileName};Extended Properties='Excel 8.0;HDR=YES;IMEX=1';Mode=ReadWrite;Persist Security Info=False;
Office 2010+
Provider=Microsoft.ACE.OLEDB.12.0;Data Source={_FileName};Extended Properties='Excel 12.0;HDR=YES;IMEX=1';Mode=ReadWrite;Persist Security Info=False;
2.没有安装ACE驱动
Microsoft ACE:AccessDatabaseEngine 下载地址:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255
版权声明:本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网