blocks|key|5244410|text|使用Excel中的“外部数据”。它可以使用ODBC连接从外部源获取数据:+Data/Get+external+Data/New+Database+Query|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5244411|这样，即使数据库中的数据发生更改，您也可以轻松地进行刷新。|5244412|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Use "External data" from Excel. It can use ODBC connection to fetch data from external source: Data/Get External Data/New Database Query

That way, even if the data in the database changes, you can easily refresh.

blocks|key|2989520|text|SSIS对于做这样的事情是不费吹灰之力的，而且非常简单(这正是它的用途)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2989521|2989522|在SQL+Management+Studio中右键单击数据库|ordered-list-item|2989523|转到“任务”，然后转到“导出数据”，您将看到一个易于使用的向导。|2989524|您的数据库将成为源，您可以输入您的SQL查询|2989525|选择Excel作为目标|2989526|<>H19在向导结束时运行它|2989527|如果您愿意，也可以保存SSIS包(向导末尾有一个选项)，这样您就可以按计划或其他方式进行保存(如果需要，甚至可以打开和修改以添加更多功能)。|2989528|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

SSIS is a no-brainer for doing stuff like this and is very straight forward (and this is just the kind of thing it is for). 

<ol>
<li>Right-click the database in SQL Management Studio </li>
<li>Go to Tasks and then Export data, you'll then see an easy to use wizard.</li>
<li>Your database will be the source, you can enter your SQL query </li>
<li>Choose Excel as the target </li>
<li>Run it at end of wizard</li>
</ol>

If you wanted, you could save the SSIS package as well (there's an option at the end of the wizard) so that you can do it on a schedule or something (and even open and modify to add more functionality if needed).

blocks|key|5244713|text|我找到了一种将查询结果从SQL+Server+Management+Studio2005导出到Excel的简单方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5244714|1)选择菜单项Query+->+Query+Options。|5244715|2)复制或保存Results+->时，选中results+->+->+Include+column+headers中的复选框。|offset|length|style|BOLD|5244716|之后，当您选择全部并复制查询结果时，您可以将它们粘贴到Excel中，列标题将显示出来。|5244717|entityMap^0|0|0|Z|S|0|0|17|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@$F|T|G|U|H|I]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

I've found an easy way to export query results from SQL Server Management Studio 2005 to Excel.

1) Select menu item Query -> Query Options.

2) Set check box in Results -> Grid -> Include column headers when copying or saving the results.

After that, when you Select All and Copy the query results, you can paste them to Excel, and the column headers will be present.

blocks|key|3834473|text|See+this|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3834474|3834475|这是迄今为止从SQL导出到excel的最佳帖子：|3834476|http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926|3834477|引用用户madhivanan的话：|style|CODE|3834478|除了使用DTS和导出向导外，我们还可以使用此查询将数据从SQL+Server2000导出到Excel。|3834479|创建一个名为these的Excel文件，其标题与表列的标题相同，并使用以下查询|3834480|1将数据从SQL+Server表导出到现有EXCEL文件|3834481|insert+into+OPENROWSET('Microsoft.Jet.OLEDB.4.0',+
++++'Excel+8.0;Database=D:\testing.xls;',+
++++'SELECT+*+FROM+[SheetName$]')+select+*+from+SQLServerTable|code-block|syntax|javascript|3834482|2将数据从Excel导出到新的SQL+Server表|3834483|select+*+
into+SQLServerTable+FROM+OPENROWSET('Microsoft.Jet.OLEDB.4.0',+
++++'Excel+8.0;Database=D:\testing.xls;HDR=YES',+
++++'SELECT+*+FROM+[Sheet1$]')|3834484|3将数据从Excel导出到现有SQL+Server表|3834485|Insert+into+SQLServerTable+Select+*+FROM+OPENROWSET('Microsoft.Jet.OLEDB.4.0',+
++++'Excel+8.0;Database=D:\testing.xls;HDR=YES',+
++++'SELECT+*+FROM+[SheetName$]')|3834486|4如果您不想预先创建一个EXCEL文件，而想要将数据导出到该文件中，请使用|3834487|EXEC+sp_makewebtask+
++++@outputfile+=+'d:\testing.xls',+
++++@query+=+'Select+*+from+Database_name..SQLServerTable',+
++++@colheaders+=1,+
++++@FixedFont=0,@lastupdated=0,@resultstitle='Testing+details'|3834488|(现在您可以查找包含表格格式数据的文件)|3834489|5要将数据导出到新的带有标题(列名)的EXCEL文件，请创建以下步骤|3834490|create+procedure+proc_generate_excel_with_columns
(
++++@db_name++++varchar(100),
++++@table_name+varchar(100),+++
++++@file_name++varchar(100)
)
as

--Generate+column+names+as+a+recordset
declare+@columns+varchar(8000),+@sql+varchar(8000),+@data_file+varchar(100)
select+
++++@columns=coalesce(@columns%2B',','')%2Bcolumn_name%2B'+as+'%2Bcolumn_name+
from+
++++information_schema.columns
where+
++++table_name=@table_name
select+@columns=''''''%2Breplace(replace(@columns,'+as+','''''+as+'),',',',''''')

--Create+a+dummy+file+to+have+actual+data
select+@data_file=substring(@file_name,1,len(@file_name)-charindex('\',reverse(@file_name)))%2B'\data_file.xls'

--Generate+column+names+in+the+passed+EXCEL+file
set+@sql='exec+master..xp_cmdshell+''bcp+"+select+*+from+(select+'%2B@columns%2B')+as+t"+queryout+"'%2B@file_name%2B'"+-c'''
exec(@sql)

--Generate+data+in+the+dummy+file
set+@sql='exec+master..xp_cmdshell+''bcp+"select+*+from+'%2B@db_name%2B'..'%2B@table_name%2B'"+queryout+"'%2B@data_file%2B'"+-c'''
exec(@sql)

--Copy+dummy+file+to+passed+EXCEL+file
set+@sql=+'exec+master..xp_cmdshell+''type+'%2B@data_file%2B'+>>+"'%2B@file_name%2B'"'''
exec(@sql)

--Delete+dummy+file+
set+@sql=+'exec+master..xp_cmdshell+''del+'%2B@data_file%2B''''
exec(@sql)|3834491|创建过程后，通过提供数据库名称、表名和文件路径来执行它：|3834492|EXEC+proc_generate_excel_with_columns+'your+dbname',+'your+table+name','your+file+path'|3834493|它长达29页，但那是因为其他人展示了各种不同的方式，以及人们就如何做到这一点提出的问题。|3834494|完全按照这个思路，看看人们提出的各种问题，以及这些问题是如何解决的。我学到了相当多的知识，只是略读了一下，并使用了其中的一部分来获得预期的结果。|3834495|更新单元格的|3834496|Peter+Larson也在那里的一位成员发表了以下帖子:我认为这里缺少一件事。能够导出和导入到Excel文件是很棒的，但是更新单个单元格呢？或者一系列的单元格？|BOLD|3834497|这是你如何管理它的原则|3834498|update+OPENROWSET('Microsoft.Jet.OLEDB.4.0',+
'Excel+8.0;Database=c:\test.xls;hdr=no',+
'SELECT+*+FROM+[Sheet1$b7:b7]')+set+f1+=+-99|3834499|您还可以使用以下命令将公式添加到Excel：|3834500|update+OPENROWSET('Microsoft.Jet.OLEDB.4.0',+
'Excel+8.0;Database=c:\test.xls;hdr=no',+
'SELECT+*+FROM+[Sheet1$b7:b7]')+set+f1+=+'=a7%2Bc7'|3834501|使用T-SQL使用列名导出|3834502|成员Mladen+Prajdic也有一篇关于如何执行此here的博客文章|3834503|参考：www.sqlteam.com+(顺便说一句，这是一个很好的博客/论坛，适合任何想要从SQL+Server中获得更多信息的人)。|3834504|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/9086880/t-sql-export-to-new-excel-file/9086889#9086889|1|2|http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx|3|http://www.sqlteam.com/^0|0|8|0|0|0|0|0|1I|1|0|4|A|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|29|0|0|B|0|0|0|M|0|0|0|7|0|0|10|R|4|2|0|0|1V|3|F|3|0^^$0|@$1|2|3|4|5|6|7|2J|8|@]|9|@$A|2K|B|2L|1|2M]]|C|$]]|$1|D|3|-4|5|6|7|2N|8|@]|9|@]|C|$]]|$1|E|3|F|5|6|7|2O|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|2P|8|@]|9|@$A|2Q|B|2R|1|2S]]|C|$]]|$1|I|3|J|5|6|7|2T|8|@$A|2U|B|2V|K|L]]|9|@]|C|$]]|$1|M|3|N|5|6|7|2W|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|2X|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|2Y|8|@]|9|@]|C|$]]|$1|S|3|T|5|U|7|2Z|8|@]|9|@]|C|$V|W]]|$1|X|3|Y|5|6|7|30|8|@]|9|@]|C|$]]|$1|Z|3|10|5|U|7|31|8|@]|9|@]|C|$V|W]]|$1|11|3|12|5|6|7|32|8|@]|9|@]|C|$]]|$1|13|3|14|5|U|7|33|8|@]|9|@]|C|$V|W]]|$1|15|3|16|5|6|7|34|8|@]|9|@]|C|$]]|$1|17|3|18|5|U|7|35|8|@]|9|@]|C|$V|W]]|$1|19|3|1A|5|6|7|36|8|@]|9|@]|C|$]]|$1|1B|3|1C|5|6|7|37|8|@]|9|@]|C|$]]|$1|1D|3|1E|5|U|7|38|8|@]|9|@]|C|$V|W]]|$1|1F|3|1G|5|6|7|39|8|@]|9|@]|C|$]]|$1|1H|3|1I|5|U|7|3A|8|@]|9|@]|C|$V|W]]|$1|1J|3|1K|5|6|7|3B|8|@]|9|@]|C|$]]|$1|1L|3|1M|5|6|7|3C|8|@]|9|@]|C|$]]|$1|1N|3|1O|5|6|7|3D|8|@]|9|@]|C|$]]|$1|1P|3|1Q|5|6|7|3E|8|@$A|3F|B|3G|K|1R]]|9|@]|C|$]]|$1|1S|3|1T|5|6|7|3H|8|@$A|3I|B|3J|K|1R]]|9|@]|C|$]]|$1|1U|3|1V|5|U|7|3K|8|@]|9|@]|C|$V|W]]|$1|1W|3|1X|5|6|7|3L|8|@$A|3M|B|3N|K|1R]]|9|@]|C|$]]|$1|1Y|3|1Z|5|U|7|3O|8|@]|9|@]|C|$V|W]]|$1|20|3|21|5|6|7|3P|8|@$A|3Q|B|3R|K|1R]]|9|@]|C|$]]|$1|22|3|23|5|6|7|3S|8|@$A|3T|B|3U|K|1R]]|9|@$A|3V|B|3W|1|3X]]|C|$]]|$1|24|3|25|5|6|7|3Y|8|@$A|3Z|B|40|K|1R]]|9|@$A|41|B|42|1|43]]|C|$]]|$1|26|3|-4|5|6|7|44|8|@]|9|@]|C|$]]]|27|$28|$5|29|2A|2B|C|$2C|2D]]|2E|$5|29|2A|2B|C|$2C|H]]|2F|$5|29|2A|2B|C|$2C|2G]]|2H|$5|29|2A|2B|C|$2C|2I]]]]

<a href="https://stackoverflow.com/questions/9086880/t-sql-export-to-new-excel-file/9086889#9086889">See this</a>

<hr>

This is by far the best post for exporting to excel from SQL:

<a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926" rel="nofollow noreferrer">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926</a>

To quote from user <code>madhivanan</code>,

Apart from using DTS and Export wizard, we can also use this query to export data from SQL Server2000 to Excel

Create an Excel file named testing having the headers same as that of table columns and use these queries

1 Export data to existing EXCEL file from SQL Server table

<pre><code>insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
 'Excel 8.0;Database=D:\testing.xls;', 
 'SELECT * FROM [SheetName$]') select * from SQLServerTable
</code></pre>

2 Export data from Excel to new SQL Server table

<pre><code>select * 
into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
 'Excel 8.0;Database=D:\testing.xls;HDR=YES', 
 'SELECT * FROM [Sheet1$]')
</code></pre>

3 Export data from Excel to existing SQL Server table

<pre><code>Insert into SQLServerTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
 'Excel 8.0;Database=D:\testing.xls;HDR=YES', 
 'SELECT * FROM [SheetName$]')
</code></pre>

4 If you dont want to create an EXCEL file in advance and want to export data to it, use

<pre><code>EXEC sp_makewebtask 
 @outputfile = 'd:\testing.xls', 
 @query = 'Select * from Database_name..SQLServerTable', 
 @colheaders =1, 
 @FixedFont=0,@lastupdated=0,@resultstitle='Testing details'
</code></pre>

(Now you can find the file with data in tabular format)

5 To export data to new EXCEL file with heading(column names), create the following procedure

<pre><code>create procedure proc_generate_excel_with_columns
(
 @db_name varchar(100),
 @table_name varchar(100), 
 @file_name varchar(100)
)
as

--Generate column names as a recordset
declare @columns varchar(8000), @sql varchar(8000), @data_file varchar(100)
select 
 @columns=coalesce(@columns+',','')+column_name+' as '+column_name 
from 
 information_schema.columns
where 
 table_name=@table_name
select @columns=''''''+replace(replace(@columns,' as ',''''' as '),',',',''''')

--Create a dummy file to have actual data
select @data_file=substring(@file_name,1,len(@file_name)-charindex('\',reverse(@file_name)))+'\data_file.xls'

--Generate column names in the passed EXCEL file
set @sql='exec master..xp_cmdshell ''bcp " select * from (select '+@columns+') as t" queryout "'+@file_name+'" -c'''
exec(@sql)

--Generate data in the dummy file
set @sql='exec master..xp_cmdshell ''bcp "select * from '+@db_name+'..'+@table_name+'" queryout "'+@data_file+'" -c'''
exec(@sql)

--Copy dummy file to passed EXCEL file
set @sql= 'exec master..xp_cmdshell ''type '+@data_file+' &gt;&gt; "'+@file_name+'"'''
exec(@sql)

--Delete dummy file 
set @sql= 'exec master..xp_cmdshell ''del '+@data_file+''''
exec(@sql)
</code></pre>

After creating the procedure, execute it by supplying database name, table name and file path:

<pre><code>EXEC proc_generate_excel_with_columns 'your dbname', 'your table name','your file path'
</code></pre>

Its a whomping 29 pages but that is because others show various other ways as well as people asking questions just like this one on how to do it.

Follow that thread entirely and look at the various questions people have asked and how they are solved. I picked up quite a bit of knowledge just skimming it and have used portions of it to get expected results.

To update single cells

A member also there Peter Larson posts the following:
I think one thing is missing here. It is great to be able to Export and Import to Excel files, but how about updating single cells? Or a range of cells?

This is the principle of how you do manage that

<pre><code>update OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=c:\test.xls;hdr=no', 
'SELECT * FROM [Sheet1$b7:b7]') set f1 = -99
</code></pre>

You can also add formulas to Excel using this:

<pre><code>update OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=c:\test.xls;hdr=no', 
'SELECT * FROM [Sheet1$b7:b7]') set f1 = '=a7+c7'
</code></pre>

Exporting with column names using T-SQL

Member Mladen Prajdic also has a blog entry on how to do this <a href="http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx" rel="nofollow noreferrer">here</a>

References: <a href="http://www.sqlteam.com" rel="nofollow noreferrer">www.sqlteam.com</a> (btw this is an excellent blog / forum for anyone looking to get more out of SQL Server).

blocks|key|2989584|text|如果您正在寻找即席项目，而不是要放入SSIS中的项目。在SSMS中，只需突出显示结果网格，复制，然后粘贴到excel中，这并不美观，但却很有效。然后，您可以保存为原生.xls而不是.csv|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2989585|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are looking for ad-hoc items rather than something that you would put into SSIS. From within SSMS simply highlight the results grid, copy, then paste into excel, it isn't elegant, but works. Then you can save as native .xls rather than .csv

blocks|key|751142|text|下面的视频将逐步向您展示如何将数据导出到Excel。对于需要导出到Excel的“一次性”问题，这是一个很好的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|751143|Ad-Hoc+Reporting|offset|length|751144|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlservervideos.com/tips-n-tricks/adhoc-reporting^0|0|0|G|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Here's a video that will show you, step-by-step, how to export data to Excel. It's a great solution for 'one-off' problems where you need to export to Excel: 
<a href="http://www.sqlservervideos.com/tips-n-tricks/adhoc-reporting" rel="noreferrer">Ad-Hoc Reporting</a>

blocks|key|3834256|text|在Excel中完成这项工作要容易得多。！！打开Excel+Data>Import/Export+Data>Import+Data在文件名旁边单击"New+Source“按钮在”欢迎使用数据连接向导“上，选择Microsoft+SQL+Server。单击下一步。输入服务器名称和凭据。从下拉列表中，选择包含所需表的数据库。选择您的表，然后选择下一步.....如果愿意，请输入描述，然后单击Finish。当您完成并返回到Excel时，只需单击“确定”轻松。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3834257|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It's a LOT easier just to do it from within Excel.!!
Open Excel
Data>Import/Export Data>Import Data
Next to file name click "New Source" Button
On Welcome to the Data Connection Wizard, choose Microsoft SQL Server.
Click Next.
Enter Server Name and Credentials.
From the drop down, choose whichever database holds the table you need.
Select your table then Next.....
Enter a Description if you'd like and click Finish.
When your done and back in Excel, just click "OK" 
Easy.

blocks|key|3834302|text|创建excel数据源并插入值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3834303|insert+into+OPENROWSET('Microsoft.Jet.OLEDB.4.0',+
'Excel+8.0;Database=D:\testing.xls;',+
'SELECT+*+FROM+[SheetName$]')+select+*+from+SQLServerTable|code-block|syntax|javascript|3834304|欲了解更多信息，请访问http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926。|offset|length|3834305|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926^0|0|0|B|1I|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Create the excel data source and insert the values,

<pre><code>insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=D:\testing.xls;', 
'SELECT * FROM [SheetName$]') select * from SQLServerTable
</code></pre>

More informations are available here
<a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926" rel="nofollow">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926</a>

blocks|key|751165|text|您可以始终使用ADO将结果从记录集对象写出到工作表单元格|type|unstyled|depth|inlineStyleRanges|entityRanges|data|751166|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You could always use ADO to write the results out to the worksheet cells from a recordset object

blocks|key|3834335|text|一个方便的工具Convert+SQL+to+Excel无需编程就可以将SQL表或SQL查询结果转换成Excel文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3834336|主要功能-将SQL表转换/导出为Excel文件-将多个表(多个查询结果)转换/导出为多个Excel工作表。-支持灵活的TSQL查询，可以有多条SELECT语句，也可以有其他复杂的查询语句。|3834337|向你致敬，亚历克斯|3834338|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlmgmt.com/ProductDetail.aspx?Id=108^0|7|K|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

A handy tool <a href="http://sqlmgmt.com/ProductDetail.aspx?Id=108" rel="nofollow">Convert SQL to Excel</a> converts SQL table or SQL query result to Excel file without programming.

Main Features
- Convert/export a SQL Table to Excel file
- Convert/export multiple tables (multiple query results) to multiple Excel worksheets.
- Allow flexible TSQL query which can have multiple SELECT statements or other complex query statements.

B. Regards,
Alex

blocks|key|3834397|text|有几种工具可以从SQL+Server导出/导入到Excel。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3834398|谷歌是你的朋友:-)|3834399|我们在这里使用DbTransfer+(它也可以将一个完整的数据库导出到Excel文件)：http://www.dbtransfer.de/Products/DbTransfer。|offset|length|3834400|我们以前用过sql+server的openrowset功能，但我对它一直不满意，因为它不太容易使用，缺乏功能和速度……|3834401|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dbtransfer.de/Products/DbTransfer^0|0|0|18|18|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$F|U|G|V|1|W]]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

There exists several tools to export/import from SQL Server to Excel.

Google is your friend :-)

We use DbTransfer (which is one of those which can export a complete Database to an Excel file also) here: <a href="http://www.dbtransfer.de/Products/DbTransfer" rel="nofollow">http://www.dbtransfer.de/Products/DbTransfer</a>.

We have used the openrowset feature of sql server before, but i was never happy with it, becuase it's not very easy to use and lacks of features and speed...

blocks|key|3834584|text|尝试使用“导入和导出数据(32位)”工具。在安装MS+SQL+Management+Studio+Express+2012之后可用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3834585|有了这个工具，很容易选择一个数据库，一个表，或插入您自己的SQL查询和选择一个目标(例如，MS+Excel文件)。|3834586|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Try the 'Import and Export Data (32-bit)' tool. Available after installing MS SQL Management Studio Express 2012.

With this tool it's very easy to select a database, a table or to insert your own SQL query and choose a destination (A MS Excel file for example).

blocks|key|5245019|text|您可以右键单击SQL+server中的结果网格，然后选择另存为CSV。您可以将其导入到Excel中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5245020|Excel为您提供了导入向导，请确保选择逗号分隔。当我需要将50k%2B记录导入excel时，它可以很好地工作。|5245021|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

you can right click on a grid of results in SQL server, and choose save as CSV. you can then you can import this into Excel. 

Excel gives you a import wizard, ensure you select comma delimited. it works fine for me when i needed to import 50k+ records into excel.

blocks|key|2990045|text|看看这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2990046|Query+->+Query+Options.

Results+->+Grid+->+Include+column+headers+when+copying+or+saving+the+results|code-block|syntax|javascript|2990047|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Check this.

<pre><code>Query -&gt; Query Options.

Results -&gt; Grid -&gt; Include column headers when copying or saving the results
</code></pre>

I have a simple SQL 'Select' query, and I'd like to dump the results into an Excel file. I'm only able to save as .csv and converting to .xls creates some super ugly output. In any case, as far as I can tell (using Google) this doesn't seem to be so straight forward. Any help would be greatly appreciated.

How do you transfer or export SQL Server 2005 data to Excel

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个简单的SQL 'Select‘查询，我想将结果转储到一个Excel文件中。我只能保存为.csv格式，转换为.xls格式会产生一些非常难看的输出。在任何情况下，据我所知(使用谷歌)，这似乎不是那么直接。任何帮助都将不胜感激。

问如何将SQL Server2005数据传输或导出到Excel
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将SQL Server2005数据传输或导出到ExcelEN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将SQL Server2005数据传输或导出到Excel
EN