Excel导入SQL,OLEDB4.0为空
Excel导入SQL,OLEDB4.0为空
语句:
1、insert into DataBoardMainDataPreSave select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;user id=;passport=;HDR=Yes;IMEX=1;DATABASE=c:\看板卡打印.xls',sheet1$)
2、select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;HDR=Yes;IMEX=1;DATABASE=" & fileName & "',sheet1$)
注:Excel文件为本地文件,SQL服务器不是本机,出现报错:
消息 7399,级别 16,状态 1,第 1 行
The OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
消息 7303,级别 16,状态 1,第 1 行
Cannot initialize the data source object of OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)".
查了很多都不行,感谢各位大虾,给看看!