将数据从sql R2 2008导出到Excel 2007 [英] Export data from sql R2 2008 to Excel 2007

问题描述

我如何从Sql server 2008 R2导出到MS-Excel 2007，我曾尝试使用MS-Excel 2003，它工作正常但不适用于2007.so代码有任何变化请提供

How can i export at from Sql server 2008 R2 to MS-Excel 2007, i had tried with MS-Excel 2003 and it works fine but dont work with 2007.so there is any change in code please provide

推荐答案

看看这个



http://blog.sqlauthority.com/2008/01/08/sql-server -2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet / [ ^ ]



希望这对您有所帮助！

Check out this

http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/[^]

Hope this will help you!

将数据导出到excel 2007的简单方法是使用SQL Server Management Studio。有关使用SSMS将数据导出到Excel的详细文章很少。首先是关于如何将表导出到excel sqlbak.com/blog/export-sql-table-to- Excel中/ 。第二个是关于如何将bak文件导出到excel sqlbak.com/blog/export -data-从-A-BAK文件到Excel / 。希望它有用

An easy way to export data to excel 2007 is to use SQL Server Management Studio. There are few detailed articles about exporting data to excel, using SSMS. First is about how to export table to excel sqlbak.com/blog/export-sql-table-to-excel/. Second is about how to export bak file to excel sqlbak.com/blog/export-data-from-a-bak-file-to-excel/. Hope it would be useful

这篇关于将数据从sql R2 2008导出到Excel 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！