Merging With Microsoft Word

[Guest]

My problem is a two stage situation.

1) I was given a word document that has over 4,100 separate data items and
it was designed to be a merge document. Will it be possible to use an Access
database to hold the data?

I understand that 2) Access can only handle it's tables holding just under
200 rows per table. By my calculations, I would have to have almost 20
tables to hold the data.

The main problem I guess I face is, all the table fields must be available
in order to place in the word documents as merge fields. Is there a way to
get Access to be able to have all the fields available for Microsoft Word to
access?

 

[John Spencer]

Access tables have a maximum of 255 fields (Columns)
A record (row) can hold up to 2000 bytes of information.
A table can have many rows - the number is dependent on the size of the
database - which is up to 2 gigs in size.

-
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..