Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sql server 2008 copy/paste started doing only 1 column

Posted on 2011-09-21
8
Medium Priority
?
234 Views
Last Modified: 2012-06-21
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
Comment
Question by:JC_Lives
  • 4
  • 4
8 Comments
 
LVL 16

Expert Comment

by:carsRST
ID: 36574102
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
 

Author Comment

by:JC_Lives
ID: 36574129
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
 
LVL 16

Expert Comment

by:carsRST
ID: 36574157
Does it do this JUST for these query results or ANY query results?

0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:JC_Lives
ID: 36574164
Any! Weird right?
0
 
LVL 16

Accepted Solution

by:
carsRST earned 2000 total points
ID: 36574180
Yes, I can't reproduce for the life of me.

Have you closed both applications and tried again?
0
 

Author Comment

by:JC_Lives
ID: 36574196
Shoot, the old "restart both"... thanks!!!! it worked!!!
0
 
LVL 16

Expert Comment

by:carsRST
ID: 36574201
LOL!

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

Glad you're back on track.
0
 

Author Comment

by:JC_Lives
ID: 36574214
Yea... lol thanks carsRST.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question