如何将Select查询结果保存到EXCEL中_[SQL Server教程]

Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/3 6:43:58
如何将Select查询结果保存到EXCEL中_[SQL Server教程]

(1)创建EXCEL文件c:\temp.xls
(2)执行查询
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=c:\temp.xls',sheet1)
select * from tablename

同样在sql server中查询excel的记录

select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=c:\temp.xls',sheet1)

来源:http://blog.csdn.net/lee576/archive/2006/11/29/1420916.aspx

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)

QQ:154298438
QQ:417480759