Hi,

I have an Excel file which I have opened in Access to create an access table
which is fine.  I am now quickly going through the fields to tweak them to
what they should be but the Excel file was created from a Lotus Approach
database that had a field which was autonumber.  Obviously when I try to
change the field in the Access database it tells me that it can not do this
as there is data in the table.

What is the proper procedure to do this and either make the field an
autonumber field during conversion or after?