I am linking Excel & Access in a database and Excel doesn't like the AutoNumber set in Access as a primary key.

Can anyone help me with ideas to set up Column A of the Excel Table to generate a series of numbers (to infinity????) as each new record is created in Access (represented as a new record per row in Excel)

Would be extremely grateful for some help