Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Results to Excel file
Message
From
21/11/2007 14:14:10
 
 
To
21/11/2007 11:42:35
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:
01270545
Views:
14
>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.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform