>Does anyone know what datatype a MS Word 97/2000 document should be saved in SQL Server 7?
If your file is less than 8000 bytes (note this is not 8K, which is 8 * 1024) then you could use
varbinary. Anything bigger would have to use
image.
FYI: A couple of years ago I tried using SQLEXEC() to store large text strings in a Sybase table and found it would not work. An updateable view however did work. I'm curious (and I'm sure others also) to see which route you go down, so please post a response when you get it to work.
censored.