I have tried this in VFP 6 and 7 using BLOB, LONG and LONG RAW on Oracle8 side. Then trying with Memo and Memo binary on VFP remote view. Also tried with SPT. And tried with Oracle and MS Oracle ODBC drivers. I can not get any combination to save the word doc back to the source table. I have not tried ADO yet.

Mark,

On advice from some Oracle folks, I separated the attachment table into 2 pieces, one with all the descriptive info about the file and then a two column table to store just the doc/xls or whatever file. The two field table in Oracle is called Attach2.

CID        CHAR(6)   -- primary key links one to one to Attach1
DataFile   Long Raw  -- hold external file

I set up a remote view where datafile is mapped to a regular memo field. To get the data into the memo field, the file name is stored in m.lcDOC and the command I use is:

APPEND MEMO DataFile FROM (m.lcDoc) OVERWRITE

To extract the data I use

COPY MEMO DataFile TO (m.lcFile)    && lcFile is the destination path and name

I use this in both Oracle and SQL*Server and it seems to work fine -- although the file to string stuff seems to be the recommended approach.

Kevin