OLEDB4.0 ISAM 错误 (.net中用oledb4.0打开excel ,注意点)

.net中用oledb4.0打开excel ,注意点。
            string path = "c:\\test.xls";
            string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + path + ";Extended Properties='Excel 8.0;'";
            OleDbConnection objConn = new OleDbConnection(strConn);
            objConn.Open();
-----------------------------------------------------------------
注意-  Excel 8.0;要用'括起来。
否则会出现 “Could not find installable ISAM”(找不到可安装的 ISAM) 错误信息.
很容易不小心犯这个小错误。
参照 http://support.microsoft.com/kb/257819/cn

 

转载于:https://www.cnblogs.com/robotplayer/archive/2008/02/18/1072539.html