Wednesday, 28 August 2013

Copy query output data from SQL SERVER 2012 and paste to Excel

Copy query output data from SQL SERVER 2012 and paste to Excel

I have a column that has data type varchar(max). Some rows in that column
have long text data. When I copy the SQL result set from that column and
paste to excel, the row gets split into multiple rows. I want to past in
sunch a way that single cell data from SQL server go to single cell in
excel. I am not sure how to fix that problem. Any suggestion would be
appreciated. Thank you

No comments:

Post a Comment