Auto generate reference number

[JonB1]

Hello,

I have a question about the auto-generate number feature in access tables.

I want to paste records that have unique reference numbers from an excel sheet into my access data table.

However when I do this Access changes the reference numbers as the relevant column in the table automatically generates a number series.

Is there any way of turning off this auto generate feature?

Thanks,


JonB

[alansidman]

Instead of pasting the data into Access, consider doing a data import. This will allow you to set the primary key as the one in your source document.

Alan