importing/copying Autonumber data

  • Thread starter Thread starter TimSullivan
  • Start date Start date
T

TimSullivan

Hello
I have a two seperate databases. Both databases have the
same field names. However the data in each of them is
different. Database "A" has a field called "job number"
it is a autonumber field starting at number 1 and it has a
couple of thousand records. Database "B" has the
same "Job number" field and is also a autonumber field.
It starts at 10,000 and also has several thousand records.

I want to copy a portion of database "B" records into
database "A" and keep the same Job Number.
When I try to copy data from "B" into "A" new Job numbers
are assigned and I can not have that.
Linkings tables won't work as the end users have the
databases on their laptops and are not connected
Any ideas????
Tim
 
You should be able to append the data from Table 2, autonumber and all, to
Table 1. You'll run into a problem, of course, if the autonumber value is
already in use.
 
Back
Top