468,316 Members | 1,989 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Exporting Result Table directly in .xls (Excel) file

Is there a command so that instead of displaying the result table (for example the result of the following query) in the grid tab in the SQL Server Analyzer environment, to export it into an .xls file (excel file)?

Expand|Select|Wrap|Line Numbers
  1. select *
  2. from table1
  3.  
Many thanks.
Nov 13 '08 #1
2 1430
ck9663
2,878 Expert 2GB
On your query window...

Tools - Options - Query Result - SQL Server - General - Default Destination for results: Results to File


-- CK
Nov 13 '08 #2
Many thanks for your help!
Nov 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Chris | last post: by
6 posts views Thread by Sharon | last post: by
1 post views Thread by Mustufa Baig | last post: by
21 posts views Thread by bobh | last post: by
4 posts views Thread by deejayquai | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.