Copy/Pasting data from SQL Server to Excel splits up text into multiple columns?

Posted by Paul on Super User See other posts from Super User or by Paul
Published on 2012-03-05T12:05:12Z Indexed on 2012/09/25 15:40 UTC
Read the original article Hit count: 185

Filed under:

copy-paste

I've got a problem pasting data from the result grid of SQL Server 2005 to an excel 2007 spreadsheet.

I have a query in SQL Server that returns 2 columns (a number column and a text column)

On one computer here i can happily copy (right-click > copy) and then just right-click and paste into an excel spreadsheet. no problem.

On another computer here when i try and paste into excel it splits the text column up and pastes the text into multiple columns based on spaces between words.

For example if one of the rows has...

Paste me please

...in it then when pasting into excel it splits the text and pastes each work into a seperate column within excel.

We've tried comparing options in both SQL Server & excel with the computer it works fine on but can see no differences.

Any ideas welcome

Thanks

Related posts about copy-paste

Windows7 and Virtual PC guest copy/paste intermittent delay

as seen on Super User - Search for 'Super User'
I've been using Virtual PC for some time now and have not had any issues with copy and paste until I upgraded my host to Windows7 64-bit. After the upgrade sometimes when I copy and paste some text there is like a 15-20 second delay before it completes, this is very frustrating when I'm trying to… >>> More
Fmylife javascript copy-paste into link

as seen on Stack Overflow - Search for 'Stack Overflow'
Fmylife.com has a nifty feature that when you copy the text from a post, it actually copies a LINK (html) so that when you paste it into your email/facebook/instant messenger/twitter/whatever it automatically will link to the post, giving them more traffic and more page views and more ad revenue,… >>> More
Is copy paste programming bad ?

as seen on Programmers - Search for 'Programmers'
With plain google as well as google code search tools it is easy to find how to program using some resource or solve certain problems ( such as a Java class, or a ftp block in perl etc) and so developers are so tempted to just purely copy paste the code (in a way re-use) - is this an incompetency… >>> More
UITextField in UIAlertView doesn't respond to cut/copy/paste on second showing

as seen on Stack Overflow - Search for 'Stack Overflow'
I"m adding a UITextView to a UIAlertView with the following code: UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Enter Name Here" message:@"this gets covered!" delegate:self cancelButtonTitle:@"Dismiss" otherButtonTitles:@"OK!", nil]; UITextField *myTextField = [[UITextField alloc] initWithFrame:CGRectMake(12… >>> More
UITextField in UIAlertView doesn't respond to cut/copy/paste on second showing

as seen on Stack Overflow - Search for 'Stack Overflow'
Edit Reposting... I accidentally marked my previous question as "commuity wiki" and didn't realize that answers to wiki posts don't generate reputation. I"m adding a UITextView to a UIAlertView with the following code: UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Enter Name Here" message:@"this… >>> More

Developer IT