Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Results to Excel file
Message
De
21/11/2007 14:14:10
 
 
À
21/11/2007 11:42:35
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
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:
01270545
Vues:
13
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform