Exporting long text fields to Excel

I have a query that exports to an Excel spreadsheet. One of the columns in a
long text field (defined as ntext (16)). When I run the query and export to
Excel the text is truncated at 255 characters. How do I get all the text to
export?
Thanks,
Bob Boles
This isn't an issue with SQL Server - it's that Excel has a 255
characters/cell limit.
There seem to be cases where Excel will allow a cell to 'contain' more
characters, but will not display any of them. Instead the cell displays
pound signs. You have to manually edit the cell contents, cutting out
characters that exceed the maximum and pasting them in to another cell.
You may want to export the text in multiple 255 character (or fewer) chunks
"Bob Boles" wrote:

> I have a query that exports to an Excel spreadsheet. One of the columns in a
> long text field (defined as ntext (16)). When I run the query and export to
> Excel the text is truncated at 255 characters. How do I get all the text to
> export?
> Thanks,
> Bob Boles

Exporting long text fields to Excel

I have a query that exports to an Excel spreadsheet. One of the columns in a
long text field (defined as ntext (16)). When I run the query and export to
Excel the text is truncated at 255 characters. How do I get all the text to
export?
Thanks,
Bob BolesThis isn't an issue with SQL Server - it's that Excel has a 255
characters/cell limit.
There seem to be cases where Excel will allow a cell to 'contain' more
characters, but will not display any of them. Instead the cell displays
pound signs. You have to manually edit the cell contents, cutting out
characters that exceed the maximum and pasting them in to another cell.
You may want to export the text in multiple 255 character (or fewer) chunks
"Bob Boles" wrote:
> I have a query that exports to an Excel spreadsheet. One of the columns in a
> long text field (defined as ntext (16)). When I run the query and export to
> Excel the text is truncated at 255 characters. How do I get all the text to
> export?
> Thanks,
> Bob Boles

Exporting long text fields to Excel

I have a query that exports to an Excel spreadsheet. One of the columns in a
long text field (defined as ntext (16)). When I run the query and export to
Excel the text is truncated at 255 characters. How do I get all the text to
export?
Thanks,
Bob BolesThis isn't an issue with SQL Server - it's that Excel has a 255
characters/cell limit.
There seem to be cases where Excel will allow a cell to 'contain' more
characters, but will not display any of them. Instead the cell displays
pound signs. You have to manually edit the cell contents, cutting out
characters that exceed the maximum and pasting them in to another cell.
You may want to export the text in multiple 255 character (or fewer) chunks
"Bob Boles" wrote:

> I have a query that exports to an Excel spreadsheet. One of the columns in
a
> long text field (defined as ntext (16)). When I run the query and export t
o
> Excel the text is truncated at 255 characters. How do I get all the text t
o
> export?
> Thanks,
> Bob Boles

export table with text and ntext fields

hello,
i have to export more tables. This tables has all kind of fields
(date,text,ntext ...)
What is the best way to export this data so that the data could be later
imported on a other server ...(CSV? ....)
any ideas?
thanks
XavierDid you try using DTS?
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Xavier" <Xavier@.discussions.microsoft.com> wrote in message
news:0CDC2879-14FF-4CA6-A947-CD4B5650F683@.microsoft.com...
> hello,
> i have to export more tables. This tables has all kind of fields
> (date,text,ntext ...)
> What is the best way to export this data so that the data could be later
> imported on a other server ...(CSV? ....)
> any ideas?
> thanks
> Xavier
>|||yes - but i could not use it - because the customer did not allow dts...
I have to use only T-Sql cmds ...which the customer eill run on his server
in the Q-Analyser , so my question is:
if i have a table 3 fieldtypes (date/text/ntext) - and i want to save the
values in a flatfile(csv?) how can i do this - and what delimiter should i
use? - to be sure that the content can be restored on the other side ...
thanks
"SriSamp" wrote:

> Did you try using DTS?
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "Xavier" <Xavier@.discussions.microsoft.com> wrote in message
> news:0CDC2879-14FF-4CA6-A947-CD4B5650F683@.microsoft.com...
>
>|||You will then have to use BCP.
Check these sources to get started on the same:
http://www.databasejournal.com/feat...cle.php/3391761 and
http://www.sql-server-performance.com/bcp.asp
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Xavier" <Xavier@.discussions.microsoft.com> wrote in message
news:58F11DD1-840C-4F0C-BC69-C5EECA49B3D0@.microsoft.com...
> yes - but i could not use it - because the customer did not allow dts...
> I have to use only T-Sql cmds ...which the customer eill run on his
> server
> in the Q-Analyser , so my question is:
> if i have a table 3 fieldtypes (date/text/ntext) - and i want to save the
> values in a flatfile(csv?) how can i do this - and what delimiter should
> i
> use? - to be sure that the content can be restored on the other side ...
> thanks
>
>
>
> "SriSamp" wrote:
>|||Surely there is an out to text file in QA?
SriSamp wrote:
> You will then have to use BCP.
> Check these sources to get started on the same:
> http://www.databasejournal.com/feat...cle.php/3391761 and
> http://www.sql-server-performance.com/bcp.asp|||Yes, there is. But if you are exporiting (N)TEXT, am not sure of the length
of these in the tables that are mentioned, since QA limits the max
characters to around 8K.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Adrian Edwards" <abc@.abc.com> wrote in message
news:dlatvb$4rh$1@.nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
> Surely there is an out to text file in QA?
> SriSamp wrote:|||thanks for the suggestion,
it works well...
My only problem is what shell i do if the content of ntext is larger then 8
k
best regards
Xavier
"SriSamp" wrote:

> You will then have to use BCP.
> Check these sources to get started on the same:
> http://www.databasejournal.com/feat...cle.php/3391761 and
> http://www.sql-server-performance.com/bcp.asp
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "Xavier" <Xavier@.discussions.microsoft.com> wrote in message
> news:58F11DD1-840C-4F0C-BC69-C5EECA49B3D0@.microsoft.com...
>
>