How keep autonumbers in merged tables.

[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.

 

[Tim Ferguson]

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.

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