How to change first column as automumber of a linked table in Acce

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey everyone, Im new to Access as well as the community, I don't even know am
i asking the right question*_*
my question is: after I linked the table from Excel (with all records)in
Access, I was unable to change the first column (customerID field) into
Autonumber Data Type. Is there any way I can wort the problem out?
Thank you so much for looking at the question!
 
You cannot change a field to AutoNumber if the table has any data in it.

One approach would be to create a new empty table, identical to your current
one, except make the first field an AutoNumber. Append all of the data from
your existing table into the new table, and the next row you add to the
table should have the AutoNumber field automatically populated to one more
than the largest number already in the table.
 
Back
Top