Solved

sql server 2008 copy/paste started doing only 1 column

Posted on 2011-09-21
8
226 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
 

Author Comment

by:JC_Lives
ID: 36574164
Any! Weird right?
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.

 
LVL 16

Accepted Solution

by:
carsRST earned 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now