关于EXCEL导入SQL的问题
在SQL查询分析器的语句
SELECT *
INTO excel111
FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0', 'Excel 8.0;HDR=YES;DATABASE=F:\wjq\hhh.xls', sheet1$) AS derivedtbl_1
报错
服务器: 消息 7399,级别 16,状态 1,行 1
OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 报错。
[OLE/DB provider returned message: 找不到可安装的 ISAM。]
OLE DB 错误跟踪[OLE/DB Provider 'MICROSOFT.JET.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]。
然后,在类里的程序
if (strFileName == "") return null;
strConn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + strFileName + " ;Extended Properties=Excel 8.0; HDR=Yes";
OleDbDataAdapter excelDA = new OleDbDataAdapter("select * from [Sheet1$]", this.strConn);
DataTable ExcelDt = new DataTable();
try
{
excelDA.Fill(ExcelDt, "ExcelInfo");
}
catch (Exception ee)
{
int i = 0;
}
return ExcelDt;
这2个都有错误,第2个错误是
ServerVersion = “excelDA.SelectCommand.Connection.ServerVersion”引发了“System.InvalidOperationException”类型的异常
base {System.SystemException} = {"无效操作。连接被关闭。"}