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

Combining data from separate databases

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


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

This discussion thread is closed

Replies have been disabled for this discussion.