[DarenR]

The bug is that when copy pasting from sql to excel it has a tendacy to add blank spaces, carriage returns or shift columns randomly in data.

Microsoft has acknowledged the but but no fix is available yet.

The reason I looked into this is because I had to copy past 217k rows with 60+ columns onto an excel work book and i noticed that some of the data was weird looking. After serveral query runs and multiple attempts, I saw no pattern to the data movement.


you can read some of the issues here
http://social.msdn.m...?forum=sqltools

[depricated]

This isn't a fix but a workaround possibly:

In MS SQL Server Management Studio, go to Tools->Options->Query Results->Results to Text

I'm sure you can figure it out from there. I use this to output CSV formatted files. Excel will open a CSV as a spreadsheet.

Interesting to know about the bug. Hopefully this works though. I use 2008 still most of the time.

[DarenR]

thanks ill give that a try and let you know if it works