Re: Merging With Microsoft Word

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
..

"WT" <WT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E81C333-462C-4114-B4D0-9437C9060614@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Re: Fields?
    ... Again, rather than jumping into the more advanced methods, start with the ... beginner articles and use the Forms toolbar. ... > downloaded the sample Word document and Access database zipfile from ... I have placed both the form and the database in the ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Word and databases
    ... but in a database interface. ... maintain a word document, which would be printed, binded, and distributed. ... This became a major inconvenience for the data entry staff, ... The third column lists the designations. ...
    (microsoft.public.office.developer.automation)
  • Re: PHP Passing Variables Between Pages and Security
    ... utility and the data was then saved in the database. ... check if it was actually a Word document, and the command-line utility ...
    (comp.lang.php)
  • Re: Fields?
    ... I am sure Charles was starting to think I ... downloaded the sample Word document and Access database zipfile from ... I have placed both the form and the database in the ... When I click the Command button for "Update New" I expect that the data ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Generic Forms on-the-fly?
    ... Fetching a Word document from a database is easy. ... saving time, forget it. ... or are there other generic solutions already out there? ...
    (microsoft.public.dotnet.framework.aspnet)