Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Results to Excel file
Message
From
21/11/2007 15:55:54
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01270509
Message ID:
01270575
Views:
20
>>When I bring up a resultset in a query window in 2005, what is the easiest way to get that into an Excel file. Right now I copy and paste the data, but it doesn't bring the column headers with it, and I am colossally lazy.
>
>Under your Tools\Options menu, in the Tree choose Query Results\SQL Server\Results to Grid, check the "Include column headers when copying or saving the results". Maybe even some of the other options there might do what you want better.

I'll give that a try - thanks for the tip!
Very fitting: http://xkcd.com/386/
Previous
Reply
Map
View

Click here to load this message in the networking platform