Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 commas in the result which mess up the result when imported to Excel.
  • When I copy and paste from the grid, Excel doesn't let me to do so regardless of whether it's a remote windows or my own windows.
  • I tired to get smaller result and then copy it piece by piece, but even 2000 results don't work already, just the size like 200 results would be OK, but there are more than 20000 results.
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

You must log in to answer this question.

Browse other questions tagged .