• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

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
0
JC_Lives
Asked:
JC_Lives
  • 4
  • 4
1 Solution
 
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
 
carsRSTCommented:
Does it do this JUST for these query results or ANY query results?

0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
JC_LivesAuthor Commented:
Any! Weird right?
0
 
carsRSTCommented:
Yes, I can't reproduce for the life of me.

Have you closed both applications and tried again?
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now