MS Word Data Conversion

[Vcscwi]

Hi All,

I have a client's database who used MS Word to store text notes instead of a memo field in a table. The Word documents contain only text notes with dates. The Word document file name corresponds to the MS Access clients table IDNUM field.

I now have made a new table of IDNUM, DATE, MEMO to store and sort the data. This will provide considerable more flexibility to their database.

I'd like to make an automated function to pull the MS Word info for each client into one memo field. I am not going to bother pulling the MS Word data apart for the date and then notes. It will just be one record for each Word document.

I guess the code I'm look for help on would...

1. open the correct MS Word document
2. copy the text from the open MS Word doc
3. append it to a memo field


If anyone has any suggestions I'm all ears!

Thanks