By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Exporting Result Table directly in .xls (Excel) file

P: 7
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
Many thanks.
Nov 13 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
On your query window...

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

-- CK
Nov 13 '08 #2

P: 7
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.