sql server 2008 copy/paste started doing only 1 column

Hi experts,

I'm using SQL server and overnight it seems my settings changed. Yesterday I was copy/pasting into Excel just fine, and now when I copy my grid results into Excel, it only pastes one column with all the columns concatenated together! Check out the screen shot!?!! any ideas?  this is the screenshot of my excel file after pasting
JC_LivesAsked:
Who is Participating?
 
carsRSTConnect With a Mentor Commented:
Yes, I can't reproduce for the life of me.

Have you closed both applications and tried again?
0
 
carsRSTCommented:
In SQL Server Mgmt Studio, check that your results are posting to the "Grid"

From the menu, go to Query-->Results To-->Results to Grid


If it's already set to grid, then just do the Text To Columns function under the "Data" tab in Excel.
0
 
JC_LivesAuthor Commented:
It is set to grid... but it was not pasting this way yesterday. If I stick with your answer I'll have to do text to columns every single time I paste from SQL to excel in the future... there's got to be some way to get it back to pasting the old way don't you think?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
carsRSTCommented:
Does it do this JUST for these query results or ANY query results?

0
 
JC_LivesAuthor Commented:
Any! Weird right?
0
 
JC_LivesAuthor Commented:
Shoot, the old "restart both"... thanks!!!! it worked!!!
0
 
carsRSTCommented:
LOL!

Yeah, that's odd.  Sometimes just the basic answers work.

Glad you're back on track.
0
 
JC_LivesAuthor Commented:
Yea... lol thanks carsRST.
0
All Courses

From novice to tech pro — start learning today.