Link to home
Start Free TrialLog in
Avatar of JC_Lives
JC_LivesFlag for United States of America

asked on

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?  User generated image
Avatar of carsRST
carsRST
Flag of United States of America image

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.
Avatar of JC_Lives

ASKER

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?
Does it do this JUST for these query results or ANY query results?

Any! Weird right?
ASKER CERTIFIED SOLUTION
Avatar of carsRST
carsRST
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Shoot, the old "restart both"... thanks!!!! it worked!!!
LOL!

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

Glad you're back on track.
Yea... lol thanks carsRST.