Large text block into ntext

How can I get a block of text into an ntext field. Have tried copy and paste
out of Notepad into field in Enterprise Manager? But it truncates.
Is there a command line that will put text into specific field in specific
table?
Use the ado stream object or textcopy
have a look at this link for more info on how to do this.
http://www.indexserverfaq.com/SQLLoadADO.htm
http://www.indexserverfaq.com/TextCopy.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"EdwardH" <EdwardH@.discussions.microsoft.com> wrote in message
news:C3C68066-04B7-4C81-A7C1-E95EF0FC4E8A@.microsoft.com...
> How can I get a block of text into an ntext field. Have tried copy and
paste
> out of Notepad into field in Enterprise Manager? But it truncates.
> Is there a command line that will put text into specific field in specific
> table?
>