Storing documents in a Field

[Paul Lewis]

Is it possible to store a word document in a SQL Server field and then open
it in Word.

I have a work order application that requires systems specifications to be
supplied in a Word document and I want to "Attach" it to the work order record
so that it can be retrieved and viewed later.

Thanks

[Joe Gerstl]

Yes, you can store anything in an image field then extract it to a file. In
this case to a file with a .DOC extension then shell it. There is an example
in MSDN on how to read/write an image field. Also, if you are using VB and
ADO, a book I have found very useful is ADO 2.1 Programmer's Reference (ISBN:
1-861002-68-8) it also includes a sample on reading/writing an image feild.



"Paul Lewis" <Paul_Lewis@csgsystems.com> wrote:
>
>Is it possible to store a word document in a SQL Server field and then open
>it in Word.
>
>I have a work order application that requires systems specifications to
be
>supplied in a Word document and I want to "Attach" it to the work order
record
>so that it can be retrieved and viewed later.
>
>Thanks