2 Replies - 1814 Views - Last Post: 03 March 2014 - 06:02 AM

#1 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 592
  • View blog
  • Posts: 3,823
  • Joined: 12-January 10

So it seems sql server 2012 has a major bug

Posted 27 February 2014 - 10:40 AM

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

Is This A Good Question/Topic? 0
  • +

Replies To: So it seems sql server 2012 has a major bug

#2 depricated  Icon User is offline

  • Nero


Reputation: 2287
  • View blog
  • Posts: 5,927
  • Joined: 13-September 08

Re: So it seems sql server 2012 has a major bug

Posted 03 March 2014 - 05:27 AM

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.
Was This Post Helpful? 0
  • +
  • -

#3 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 592
  • View blog
  • Posts: 3,823
  • Joined: 12-January 10

Re: So it seems sql server 2012 has a major bug

Posted 03 March 2014 - 06:02 AM

thanks ill give that a try and let you know if it works
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1