You can store doents in SQL Server as (N)TEXT columns. See the following
links for more details:
Reading and Writing BLOBs (.NET) ==>
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316887[/url]
Reading and Writing BLOB's (DNA) ==>
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038[/url]
--
HTH,
SriSamp
Please reply to the whole group only!

"steph" <stephaniebeldinghotmail.com> wrote in message
news:08e901c34132$e30bafb0$a301280aphx.gbl...
> We're required to migrate Lotes Notes data into MS SQL
> Server as part of a migration effort. The Notes database
> stores word doents, excel doents and pdf's.
>
> How do you insert a word doent, excel file or pdf file
> into a table/column in sql server 2000.
>
> Thanks,
> Steph