Storing Word Documents in SQL Server

  • I am currently working on an application for Intensive care. One of the requirements is that the users would like to create discharge summaries in Microsoft Word and then store them in the database. I know you can store Word documents as BLOBS (I don't know how). But isn't this a little resource intensive! Is there another way to do this?

    I would be vary grateful for any advice on this subject!

  • Hi Rob,

    quote:


    I am currently working on an application for Intensive care. One of the requirements is that the users would like to create discharge summaries in Microsoft Word and then store them in the database. I know you can store Word documents as BLOBS (I don't know how). But isn't this a little resource intensive! Is there another way to do this?

    I would be vary grateful for any advice on this subject!


    http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14925

    should explain what you've asked

    Cheers,

    Frank

    Sorry, along with this one

    http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12146

    Edited by - a5xo3z1 on 08/05/2003 04:58:27 AM

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

  • Why not just store them in files and put the file location in SQL Server. Also you sure you want to do this word files that could be edited and cause all sorts of headaches (legal) how about PDFs?

  • Hi HenryTr,

    quote:


    Also you sure you want to do this word files that could be edited and cause all sorts of headaches (legal) how about PDFs?


    I'm not sure, if I understand you. Can you explain this?

    Cheers,

    Frank

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply