I have two db each have the same table called manufacturers and same fields.

db1 has a field called man_ID which is a auto increment field. This contains 90 records but over time the records have been added and deleted so the man_ID auto increment value is no longer in sequence.

db2 is new with no records.

What I need to do is insert the old manufactures records into the new db2 and keep the man_ID values...