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

  • Thread starter Thread starter OTWarrior via AccessMonster.com
  • Start date Start date
O

OTWarrior via AccessMonster.com

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.
 
OTWarrior via AccessMonster.com said:
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.
Click to expand...

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

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