import/exporting to word form, using multiple records/tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OTWarrior - 21 Jun 2007 09:28 GMT

I have a word document that a team will use to enter data into, and I need
the data to be imported into my database.

However, different sections of the document need to be inputted into
different tables.

In one case, multiple rows of a table will be added, creating multiple
records.

what is the best way of going about this?

I already have code that will write to forms, and just need to know if there
is a way of writing (adding)to multiple records at the same time on the same
table.

Any ideas would be very much appreciated.

Reply to this Message

Keith Wilby - 21 Jun 2007 09:51 GMT

>I have a word document that a team will use to enter data into, and I need
> the data to be imported into my database.

You're doing it the wrong way round (as the actress said to the bishop).
Enter the data directly into Access using forms and queries, then merge the
data to a Word document if you need to (search the help for "mail merge").

Keith.
www.keithwilby.com

Reply to this Message

OTWarrior - 21 Jun 2007 11:45 GMT

>You're doing it the wrong way round (as the actress said to the bishop).
>Enter the data directly into Access using forms and queries, then merge the
>data to a Word document if you need to (search the help for "mail merge").
>
>Keith.
>www.keithwilby.com

Actress/bishop jokes I love :)

We do already have the data doing it the way you said, which is why we want
to change it (having the data come in and out via the already filled in forms,
which will speed up the process)

I was just wondering if it is possible to add multiple rows.
would a check to see if the next row is a not a null, then doing Addrecord
work?

Reply to this Message