Import from Word into Access

[RitchieJHicks]

Hi,

We have a client who insists on sending us notifications of claims via a
Microsoft Word document template. The fields in that template never alter.

I understand that it may be possible for me to set my form to import the
data front a word document. However, I have search high and low and can find
no concise information on how to do this.

Could anyone please point me in the right direction?

Thanks.

 

[pietlinden]

Hi,

We have a client who insists on sending us notifications of claims via a
Microsoft Word document template. The fields in that template never alter..

I understand that it may be possible for me to set my form to import the
data front a word document. However, I have search high and low and can find
no concise information on how to do this.

Could anyone please point me in the right direction?

Thanks.

If the data is in the bookmarks, you could go the painful route and do
something like this in your code

1. open an instance of Word
2. open each word document
3. create a record in your database using rs.Addnew
4. set the values of the fields in your new record to the values in
the bookmarks..., e.g.
rs.fields(0)=wrdDoc.Bookmarks(0).Text
5. save the changes using rs.update
6. close the word document, go to next doc (repeat steps 3-6)