By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

How to combine separate identical databases

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <re*************@jorgensen.com> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...
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.

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.