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