JC_Lives
asked on
sql server 2008 copy/paste started doing only 1 column
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?
ASKER
Any! Weird right?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Yeah, that's odd. Sometimes just the basic answers work.
Glad you're back on track.
ASKER
Yea... lol thanks carsRST.
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.