Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export SQL Anlyzer data to excel spreadsheet

Status
Not open for further replies.

sap1958

Technical User
Joined
Oct 22, 2009
Messages
138
Location
US
Is there a way to export sql data from query analyzer direct to excel
 
Are you asking for a method other than the Save Results As... menu choice (right-click on results)? If so, then not really.

I've noticed a lot of posts here lately asking for end user application-style behavior from QA and SSMS. This is a fundamental misconception. You should use UI tools to present the data.

-------++NO CARRIER++-------
 
You can make your connection from Excel and run your query right from there. When you open your spreadsheet you can refresh the data.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top