Hi Donna,
You could use Access to link to each database and then use a make table
query and a series of append queries to create one new table. Or you could
use a union query to combine all of the tables.
If that went right over your head, a Directory type mailmerge maindocument
in which you set up the field names of one of the data sources in the cells
of a one row table in the main document. Then execute that merge and you
will get a document containing a table with all of the data records from the
database that you used as the data source. Repeat this for each database,
and then copy and paste the tables from the documents produced by the
mailmerge operations into one table so that it will contain all of the
records. Now go to the first row of that table and insert a row into which
you enter the field names. Now save this document and use it as your
datasource.
--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
