• You cannot do it this way!

    While using ADO and its' Stream Object is probably the most simple method, SQL Server offers WRITETEXT, UPDATETEXT and READTEXT. You may also want to have a look at Textcopy. A small tool that comes along with SQL Server.

    I'm sure I've posted you this link some days ago http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]