rich text output from sybase

[NickyJay]

Related to my last message - ie. transferring data from sybase to sql2005 daily - i have another issue whereby the output options using dbisql (xls, txt etc.) are not giving me an output that I can then read into 2005 correctly ;0(

Anybody any ideas how this data can be transferred and the line feeds/formatting etc. be preserved??

Thanks!

 

[NoCoolHandle]

It would need to be stored into an image column
This would allow the binary characters that normally acompany richtext data.

 

[NoCoolHandle]

or VARBINARY(Max) - sql 2005