Could not find installable ISAM

但在这次开发中，再次引用时，即出现了异常：“Could not find installable ISAM”。

奇怪！

经过一番查阅资料和修改，Insus.NET把代码稍作修改一调整：


程序又可以跑起来了...

 public static string ExcelConnectionString(string filePhysicalPath)        {            string connectionString = string.Empty;            string fileExtension = filePhysicalPath.Substring(filePhysicalPath.LastIndexOf(".") + 1);            switch (fileExtension)            {                case "xls":                    connectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"", filePhysicalPath);                    break;                case "xlsx":                    connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES\"", filePhysicalPath);                    break;            }            return connectionString;        }

Source Code