There are several factors to consider. First of all, are all the primary
keys different? If you're using autonumbers - probably not. If they are
different, then you could just create a new front end mdb and link all the
tables (it doesn't matter if they end in 1,2 etc.) and use append queries to
consolidate the data. Since there's only six tables, it's not worth the
time to create functions to do the work.
If you have autonumbers - or other duplicate primary key date - I would
create a new field on the original tables called "DatabaseName" or something
similar, change the autonumber to a long integer, and make the primary key
the new field and the autonumber. Then do the above process.
Hope this helps.
Matthew Wells
MW****@FirstByte.ent
"Reidar Jorgensen" <re*************@jorgensen.com> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...
I have several databases, identical in structure but with different data.
Is there an esay way to combine all the data into one big database? There are six
tables.