Thursday, Septem11:23:29 AM - Tariq Abulaila This works perfectly in SQL 2016 and saved me hours of work trying to get the data extracted when it kept splitting lines. Just wanted to say thank you so much! I have queries I have to run several times for my users and some of the larger fields would split up. Thursday, Octo4:32:24 PM - Jessica A Brucks but in my office with same sql version in my coworker's machine it copied fine but only in mine it happend like that. csv file, opening Excel, and opening csv file with csv import wizard. N.B.: for unknown reason, this solution doesn't worked for me when saving query result into a. Excel is interpreting double quotes as text delimiter. SELECT '"' + cast(Count圜ode as nvarchar(MAX)) + '"'ġ/ Execute query to get result into a gridģ/ Open new Excel worksheet and paste data in it. Specifying MAX as nvarchar size was necessary otherwise the result was truncated to 30 char only. It is all about embedding the ntext field between double-quotes.Īs the add function (+) can't be used with ntext, we have to cast ntext into nvarchar anyway. :)ĭon't ask me why but the following workaround is also working fine and PRESERVING ntext content format.
relieved of this issue that I have been suffereing with for so long. This was really helpful thanks a lot buddy. Unfortunately this doesn't help when you want to retain the carriage returns in excel so that the field in excel appears as multi-line text in 1 cell, not multiple columns in excel, replacing with a space or a blank string obviously won't fix this. I have the same problem and couldnt get any reasonable answer in the internet. Tuesday, Ap10:53:06 AM - Evgeny Ponamarev Clear the checkbox for "Retain CR/LF on copy or save" to get a multi-line result as a single line. Select "Tools - Options" from the SSMS menu and navigate to "Query results - SQL Server - Results to Grid". It is NOT necessary to rewrite the query, this behavior is just a setting in newer versions of SSMS. Thanks for the solution, I also had the same problem and you solution is perfect. I have the option set to allow line breaks in grid result in SSMS, which works fine, and when pasted from SSMS into Excel, I want a multi-line cell. For example, I have a table with a text cell containing a log, with separate lines. This isn't workable if one WANTS the linefeeds in the cell in Excel.
0 kommentar(er)
