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 word into a separate 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