Re: Import from Word
- From: John Nurick <j.mapSoN.nurick@xxxxxxxxxxxxxx>
- Date: Tue, 02 Jan 2007 21:07:09 +0000
Hi HillaryDiane,
How easy it is to get data out of a Word document depends on how well
the document is structured. In a situation like yours, I strongly
recommend using formfields in the document at each point where you want
the users to be able to enter anything, and then protecting the document
so they can't make any other changes. The formfields also allow some
further control over what people can type (e.g. limiting the number of
characters in a text field, selecting from a dropdown list, a
checkbox...).
It's reasonably simple to automate processing of the returned documents.
You need to write VBA code that runs in Access and automates Word to
open the document; the responses are then available in the document's
FormFields collection for your code to collect and append to a table.
On Tue, 2 Jan 2007 12:27:00 -0800, HillaryDiane
<HillaryDiane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a questionnaire I developed in Word that has some MailMerge fields
from Access with transaction details that I send out along with some
questions about the transactions. I e-mail the document to people who
respond in the Word document and e-mail it back to me. I then manually enter
their responses into the database.
Is there a way to import their responses into the database to eliminate the
manual entry? Any suggestions for other ways to automate this process?
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
- Prev by Date: Re: Grabbing a Date from Excel to use in a Access Query?
- Next by Date: Re: can I convert to first letter upper case when all are uppercase
- Previous by thread: Re: Paradox Tables...
- Next by thread: Re: can I convert to first letter upper case when all are uppercase
- Index(es):
Relevant Pages
|
