Copy/Pasting data from SQL Server to Excel splits up text into multiple columns?
- by Paul
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