How keep autonumbers in merged tables.

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a table in another database which is a SQL server
table and is linked.

I need to bring this table into another database as an
Access table. I already did this with a DTS package.

However, the autonumber column came in as a number not an
autonumber.

Now I need to merge this data into yet another table with
an autonumber key.

The resulting table will have an autonumber key.
How do I do this, keeping the same autonumbers that were
in the original tables if possible.

Is it possible to convert a table number column to an
autonumber column? If I could, this would solve my problem.
 
I need to bring this table into another database as an
Access table. I already did this with a DTS package.

However, the autonumber column came in as a number not an
autonumber.
Click to expand...

Create the receiving table first, with the field properties all set as
appropriate, and then append the data into it. You can use INSERT queries
to poke values into autonumber fields quite happily.

HTH


Tim F
 
Back
Top