D
Database User
Hi I'm trying to import records from 2 excel spreadsheets into my database.
One is customer information and the 2nd is related records customer
transactions.
They are bound together by the customer id which is in both tables. So i
would just paste them both in separately in 2 queries but the problem is that
the customer id in my database is autonumber and when i import these records
i need to keep their id that they came with because otherwise i can't paste
the related records it just says we cant find the matching customer id in the
customers table.
Basically i need 2 things a) to be able to tell my autonumber id this time
let the number that gets pasted into you remain the ID
and B) i need to program the 2nd database where this information is coming
from that the autonumber should never be the same as the autonumber in the
database to be pasted into, maybe i can add on at the end 3 numbers or
something like that.
Please can someone help
One is customer information and the 2nd is related records customer
transactions.
They are bound together by the customer id which is in both tables. So i
would just paste them both in separately in 2 queries but the problem is that
the customer id in my database is autonumber and when i import these records
i need to keep their id that they came with because otherwise i can't paste
the related records it just says we cant find the matching customer id in the
customers table.
Basically i need 2 things a) to be able to tell my autonumber id this time
let the number that gets pasted into you remain the ID
and B) i need to program the 2nd database where this information is coming
from that the autonumber should never be the same as the autonumber in the
database to be pasted into, maybe i can add on at the end 3 numbers or
something like that.
Please can someone help