I have a MSWord document that has a table with 8 rows and 2 columns. The first column lists questions (1 per row). The second column is answered either "yes" or "no".

Is there a way to retrieve that "yes" or "no" from MSAccess using VBA?

Yep, there are two ways to do this.

1. You can parse each line of the word doc, and look for a phrase from each question, then split out the answer using an array. This involves a lot of trial and error.

2. You can turn the table into a Form, and then retrieve the form fields from Access. This is more direct and there is no trial and error.
   If you use this method, you need to apply data validation to your form so that the data being entered can be readily retrieved into Access.

The question is, which one do you want to do? Are you planning this system and can therefore do your own design? If so, use the form. Have you inherited a lot of data and need an ETL solution? If so, parse the text (you may want to turn all the doc files into text files to make this easier. You can write a quick file converter in VBA to do this for you when you open your database.)

HTH

mmcdonal

It's a brand spankin' new form, so option 2 looks like it'd work well ... now, i have to figure it out ...

Thanks!

Search Word for "Create forms that users complete in Word" to get started. Also, invoke the database toolbar and see if there is anything that allows you to do data entry. You should be able to invoke the text fields etc you create in your form through the word object model, or send the data directly to the database if you save the file as html, and put in a submit button. Users should be able to open this in Word, fill out the form (protect the text sections) and then click submit. This could go to an intermediate table for approval before final submission. This is good for a local solution. Otherwise convert to txt and parse.

HTH

mmcdonal