How to merge data from two separate access 2007 databases

Posted by DiegoMaK on Stack Overflow See other posts from Stack Overflow or by DiegoMaK
Published on 2010-04-19T20:41:30Z Indexed on 2010/04/21 1:23 UTC
Read the original article Hit count: 285

Hi, I have two identical databases with same structure, database a in computer a and database b in computer b.

The data of database a*(a.accdb)* and database b*(b.accdb)* are different. then in database a i have for example ID:1, 2, 3 and in database B i Have ID:4,5,6

Then i need merge these databases data in only one database(a or b, doesn't matter) so the final database looks like. ID:1,2,3,4,5,6

I search an easy way to do this. because i have many tables. and do this by union query is so tedious.

I search for example for a backup option for only data without scheme as in postgreSQl or many others RDBMS, but i don't see this options in access 2007.

pd:only just table could be have duplicate values(I guess that pk doesn't allow copy a duplicate value and all others values will be copied well). if i wrong please correct me.

thanks for your help.

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about ms-access-2007