我用
EXEC master..xp_cmdshell 'bcp Test.dbo.GameServerInfo out E:\GameServerInfo.xls -c -q -S"chenhongfei" -U"sa" -P"111"'将Test中表GameServerInfo中的数据导入到E:\GameServerInfo.xls中成功 ,然后我用
Select
* From OpenRowSet('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\GameKindInfo.xls' , GameKindInfo)
出现错误,错误如下;Msg 7399, Level 16, State 1, Line 2
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.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".我已经启用了
xp_cmdshell 跟OpenRowSet
EXEC master..xp_cmdshell 'bcp Test.dbo.GameServerInfo out E:\GameServerInfo.xls -c -q -S"chenhongfei" -U"sa" -P"111"'将Test中表GameServerInfo中的数据导入到E:\GameServerInfo.xls中成功 ,然后我用
Select
* From OpenRowSet('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\GameKindInfo.xls' , GameKindInfo)
出现错误,错误如下;Msg 7399, Level 16, State 1, Line 2
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.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".我已经启用了
xp_cmdshell 跟OpenRowSet
* From OpenRowSet('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\GameKindInfo.xls' , GameKindInfo$)
Msg 7399, Level 16, State 1, Line 2
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.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
* From OpenRowSet('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\GameKindInfo.xls' , 'select * from [GameKindInfo$]')TRY