How to combine separate identical databases

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.

re: How to combine separate identical databases

From your single database, link to the tables in the 6 different databases.

You can create a query that UNIONs the 6 tables together, but that query
will not be updatable.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Reidar Jorgensen" <reidar_antispam@jorgensen.com> wrote in message
news:425788ae$0$14803$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
>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.[/color]

re: How to combine separate identical databases

On Sat, 09 Apr 2005 17:46:51 +1000, Reidar Jorgensen
<reidar_antispam@jorgensen.com> wrote:
[color=blue]
>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.[/color]
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