Import from Word into Access

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

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.
 
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.
Click to expand...

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)
 
Back
Top