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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to UN-check greyed-out "First Row Contains Column Headings" bo 0
Link to excel table which has keys in both row and col headers: isthis possible? 0
importing part of excel file into access 2
Linked table column type changes from text to memo 1
Linked Excel file gives #Number! error in table 5
cannot uncheck "first row contains column headings" importing XL2 0
200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC 2

Back
Top