Database Merge with Autonumber Primary Key

Zempten

Board Regular
Joined
Apr 21, 2014
Messages
55
Hello

I have 2 databases (Database A and B which have an identical structure) and I am trying to merge Database B into Database A. The problem is that the master table that I use has a autonumber field which acts as the primary key and has a relationship to a child table. If I just take import directly they will clash as duplicates. Is there anything I can do to prevent this from happening? Thanks
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,900
no, you cannot add to autonumber, just let the added records renumber.
NOW, if you have related tables on these merged recs...add a new field called [PrevIndex] and put the autonumber from the merged table in it for preservation.
Then you can renumber all related tables to the NEW autonumber indexs.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,992
Messages
5,526,109
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top