I haven't tried it myself, but what about something like:

s=FILETOSTR("WORDDOC.DOC")

UPDATE MYTABLE SET BINARYFIELD=s WHERE RECID=5

Cheers,
Peter

>Hi there!
>
>I'm just about to finish my first SQL-Server based app.
>
>I have a table on MS SQL Server where I need to store entire binary FILES (e.g. a Word Document) in a binary FIELD, but I can't figure out what syntax to use to load or retrieve that information.
>
>Could you give me a pointer as to what to do, e.g. where to look or what command to use? I can see that SQL Passthrough won't work, because I cannot use something like UPDATE MYTABLE SET BINARYFIELD=FILETOSTR("WORDDOC.DOC") WHERE RECID=5
>
>But that's really what I want to do
>
>Does anyone have any ideas as to what to do. I figure it needs an ADO object, but how???
>
>Thanks so much!
>Hermann Strijewski
>Clearwater, FL