Home > IT Answers > Microsoft Windows > Saving Query results into Excel format
Preetg
5 pts.
 Saving Query results into Excel format
Microsoft Excel, SQL Server 2005, SQL Server import/export
How can I save query results into .xls format directly from Microsoft SQL server Management studio?

Software/Hardware used:
ASKED: September 5, 2008  1:43 AM
UPDATED: September 5, 2008  1:14 PM
RELATED QUESTIONS
Answer Wiki:
You can use the Import/Export wizard by right clicking on the database, then tasks, then export data. If you are talking about after running a query, then simply select all the data, right click and select copy (or press control C) then go to Excel and paste the data.
Last Wiki Answer Submitted:  September 5, 2008  2:22 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.