Import excel to access with primary key

[billmark]

Hi
Initially, I created a table in access with primary key and copy & paste the excel to the access with the 1st column blank to for the primary key in access. Later, using docmd Transferspread, but it got an error - Null value in an auto-number field. Please advise how to fix.

 

[Calgary_Neil]

Newbie to Newbie
I would ask if your PK is an autonumber, if so don't import on to it. It don't like it period.
Neil

 

[billmark]

it works, thank