Are your separate databases in separate workbooks, or are they in the
same workbook but in different worksheets?
Does each database have the same column names and sequence of columns
/in the data source/ ?
What sequence of records do you need in your output document (i.e. do
you need the first record from each data source, followed by the second
record from each data source, etc. When one data source runs out of
records, do you any kind of placeholder or do you just want to continue
with the next available record?
(FWIW the simplest approach is likely to be to use Excel formulas or
Excel VBA code to gather all the records into a single worksheet).
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at
http://www.ralphwatson.tv
Nit_Wit_400 wrote:
Sorry; forgot to mention I'm merging into Word 2003 and Excel 2003 is
my database.