Link to home
Get AccessLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

Column wrapping when Copy&Paste or export data from SQL Server to Excel with large string column

I have a MS SQL SERVER query that I run. One of the field/columns is huge. Called Raw_Results If the results are say 1200-1400 characters long and.......
and I need to export them to a file in excel. Current version. How could I do that cleanly. 

Why because the results of that column wrap on export. Thus messing up the file because I cant get clean columns.  

Is there a way in SQL or EXCEL that might correct that. I heard that there might be a CHAR(??) function or something that might do it or maybe some setting in excel or in the SQL Export tool that can solve this problem?

ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of RUA Volunteer2?

ASKER

aikimark
Yes there may be some carriage returns in there but I am not sure how to check that other than copy the record out and past it and try to find it to see if I can find one.

I will try all the others options.
The copy & paste seems to be the most problematic. I could not find Tab-Delimiter feature in the SQL export does not seem to be obvious. These look like all good solutions I will try them. Thank you all.
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access