Changing Primary Keys

[confusimo]

I have a set of databases each with a table with one-to-many relationships to two other tables.

I want to merge the tables from one database into another, but the primary keys start at 1 for each database - and so the keys conflict when merged into one unified table.

Is there any way I can run a "batch" process in order to change the primary key across all the tables, then merge the tables with the new (and now trully unique) keys?

Perhaps something in VBA would do the job?


Thanks in advance for any help you could give me!

 

[confusimo]

Thanks so much for the help - this is exactly what I did in the end, kinda annoying to have to move it to a new table to create the new ID's - but much easier than any other way I'd imagined.


Thanks again and sorry for the late reply!