How to import data into similar DB, but unable to import the primary key?

[RSIboy]

Hi

I am revising an existing database, and have re-designed from the ground up. My problem is importing the data from the old database - specifically, that I can't import/overwrite the new Primary Key...

The old database had a customer table with CustomerID as the primary key (using Autonumber). It also has a policy table (1 customer can have many policies) which had PolicyID as the primary key (autonumber), but then also CustomerID to link the policy record to the correct customer.

In the new database I have very similar tables for customer & policy - my question is, when I link to the old table & do an append query, I will only be able to import the old CustomerID into a created field such as OldID - how will I then ensure that when I import the old policy data, it is linked to the 'new' CustomerID?

Probably as clear as mud.... ;-)

TIA

Dale
Manchester, UK

 

[bevs]

Please elaborate on teh append query

How exactly do you perform an append query, when you want to import customers from an old database to the customers in a new database and keep the old customerID?
Thx/bevs

 

[bevs]

that's the ticket...
thx Pat