Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Results to Excel file
Message
De
21/11/2007 15:55:54
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
21/11/2007 14:14:10
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01270509
Message ID:
01270575
Vues:
19
>>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/
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform