Solved

sql server 2008 copy/paste started doing only 1 column

Posted on 2011-09-21
8
227 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

809 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