On Sat, 09 Apr 2005 17:46:51 +1000, Reidar Jorgensen
<re*************@jorgensen.com> wrote:
I have several Access databases, identical in structure, but different data. Is there an
easy way to combine them all into one database? There are six tables, I just want the
data from all databases merged into one database.
Thanks in advance.
Hi
Is this something you want to do just once? You can attach to all the
other tables from one of the databases and append the tables into one
of each type using queries or even by copy and paste append. This is
easy if time-consuming.
But you will need to do more if the tables have sequential autonumber
keys which are used in relationships, as the same key values will
occur in the different databases.
David