如何将数据从sql server 2008 r-2导出到excel? [英] How to Export data from sql server 2008 r-2 to excel?
问题描述
我必须将数据从sql server导出到Excel
i am使用以下代码
< pre lang =sql> INSERT INTO OPENROWSET (' Microsoft.Jet.OLEDB.4.0',' Excel 7.0; Database = C:\ Users\manacle-03 \Desktop\user.xlsx;',
' SELECT * FROM [Sheet1 $]')
SELECT *
FROM 用户
我收到错误如
消息7303,等级16,状态1,行1
无法为链接服务器(null)初始化OLE DB提供程序Microsoft.Jet.OLEDB.4.0的数据源对象。
')
SELECT *
FROM 用户
我收到错误如
消息7303,级别16,状态1,行1
无法初始化OLE DB提供程序Microsoft.Jet.OLEDB.4.0的数据源对象链接服务器(null)。
解决
I have to export data from sql server to Excel
i am using following code
INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 7.0;Database=C:\Users\manacle-03\Desktop\user.xlsx;',
'SELECT * FROM [Sheet1$]')
SELECT *
FROM Users
I am getting Error like
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
') SELECT * FROM Users
I am getting Error like
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
Solved
这篇关于如何将数据从sql server 2008 r-2导出到excel?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!