Hi

I have an access table containing a number of fields the primary key
of which is an autonumber field. i also have another table of exactly
the same structure except with a number field instead of autonumber.
Is there any way of appending the second table to the first and still
retain the autonumber fields??

Thanks in advance

Paul