Solved

sql server 2008 copy/paste started doing only 1 column

Posted on 2011-09-21
8
225 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

707 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