Insert Word Document into SQL Server Table as Blob

Here is my problem.

I have a table of Candidates

Record_id

first_name

last_name

Resume_Text

Resume

Resume_Path

I need to insert the resume word documents on a remote drive into the database. The resume_path in the candidate table has the path for me: x:\john_doe_resume to identify which resume should be loaded for each candidate into the candidate table.

I can't seem to find any documentation on how to write a procedure to accomplish this.

Any help greatly appreciated.

While I haven't done it, here are a few references I found:

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b258038

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=243427

Hope this helps. If not, perhaps someone else has an idea.