Linking or Combining different Access Databases

[robertmeyer1]

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.

[NeoPa]

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.

[robertmeyer1]

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.

[NeoPa]

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.

[robertmeyer1]

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?

[MMcCarthy]

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

[robertmeyer1]

Thanks ya'll