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

Linking or Combining different Access Databases

P: 99
Hi,

There are several databases that have the same tables, with different reocrds. I need to be able to combine them all into 1 in an easy manner/best. How can I do this and are there potential problems for data corruption? Thanks.

(All tables are exactly identical, its the same DB copied seveal times, each has different records entered that need ot be comboned.) thanks.
Dec 14 '06 #1
Share this Question
Share on Google+
6 Replies


NeoPa
Expert Mod 15k+
P: 31,186
Unless you combine them all into one table, you'll have to define a UNION query but this is not very efficient. See threads started by Killer42 for discussions on this.
Dec 14 '06 #2

P: 99
Unless you combine them all into one table, you'll have to define a UNION query but this is not very efficient. See threads started by Killer42 for discussions on this.
I think combining them into 1 table is the way to go. Since they all have the same DB table structures, it shouldnt be too hard to insert the records. I just didn't know if there was a better way then copying and pasting.
Dec 14 '06 #3

NeoPa
Expert Mod 15k+
P: 31,186
Oh yes there is that.
Link all the tables to one front-end database and write some SQL append queries to append from one linked into your destination table. This too, can be linked if desired.
Dec 14 '06 #4

P: 99
Oh yes there is that.
Link all the tables to one front-end database and write some SQL append queries to append from one linked into your destination table. This too, can be linked if desired.
So Do I need to import the tables all into 1 DB? or simply link them where they are and create an append query?
Dec 18 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
So Do I need to import the tables all into 1 DB? or simply link them where they are and create an append query?
Link and append is fine Robert

Mary
Dec 19 '06 #6

P: 99
Thanks ya'll
Dec 19 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.