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

Question

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

possible duplicate of Copy And Paste From SQL Server Management Studio 2012 New Line Issue Into Excel — THelper
– THelper, Commented Sep 1, 2015 at 8:05

Seth Moore · Accepted Answer · 2013-08-28 17:24:10Z

2

Use Excel Import from SQL Server feature. It should import each row of data into a single row in Excel and each column into a single column.

edited Aug 28, 2013 at 17:24

answered Aug 28, 2013 at 17:18

Seth Moore

3,5452 gold badges26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Iza Pastoor · Accepted Answer · 2013-08-29 08:32:43Z

0

You can try to select data directly into excel spreadsheet.

Check this for more details http://blog.waynesheffield.com/wayne/code-library/ad-hoc-querying/#codesyntax_5

answered Aug 29, 2013 at 8:32

Iza Pastoor

1921 silver badge4 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related