I'm trying to use TEXTCOPY to insert a WORD DOCUMENT into SQL SERVER, but it fails and gives me an error message

Can anyone tell me how to insert a WORD DOCUMENT using TEXTCOPY?

I don't want to use VB / C++ etc to write a program to do this I want to run it from a sp

The below code works if I insert a jpeg / bmp etc. file but I want to use a WORD DOCUMENT


Cheers


My code:

CREATE PROCEDURE spTextcopy
(
@srvname varchar (30),
@login varchar (30),
@password varchar (30),
@dbname varchar (30),
@tbname varchar (30),
@colname varchar (30),
@filename varchar (30),
@whereclause varchar (40),
@direction char(1)
)

AS

DECLARE @exec_str varchar (255)

SELECT @exec_str =
'textcopy /S ' + @srvname +
' /U ' + @login +
' /P ' + @password +
' /D ' + @dbname +
' /T ' + @tbname +
' /C ' + @colname +
' /W "' + @whereclause +
'" /F ' + @filename +
' /' + @direction

EXEC master..xp_cmdshell @exec_str

spTextcopy @srvname = 'MyServer',
@login = 'sa',
@password = 'password',
@dbname = 'dbName',
@tbname = 'tblTest',
@colname = 'myTextCol',
@filename = 'c:\myTest.doc',
@whereclause = " WHERE myId = 2 ",
@direction = 'I'


tblTest has 3 cols :
myId int
myTextCol text
myImageCol image