Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am doing a local query through a remote desktop of a server. It is Management Studio 2005 and the result is large. Somehow, it doesn't let me to copy and paste the result.

  • csv format doesn't work since there are some comma in the result then the csv result looks mix up in excel
  • When I copy and paste from the grid, Excel doesn't let me to do so no matter in that remote windows or my own windows.
  • I tired to get smaller result then copy pieces by pieces, but even 2000 results don't work already, just the size like 200 results would be ok, but there are more than 20000 results.

Any idea how can I solve this problem at work?

share|improve this question
    
Instead of copy paste, there might be a way to save your results to file.. social.msdn.microsoft.com/Forums/sqlserver/en-US/… –  zundarz Sep 17 '13 at 4:32
1  
If you have Microsoft Excel installed, you can run import data by executing a query on a SQL server. Take a look at the section Connect a SQL Server database to your workbook in Excel's help. –  Narayanan Sep 17 '13 at 4:52
    
export works very well! –  laughingthunder Sep 17 '13 at 6:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.