Hi
I have a table that has a PK that is an auto number (Contact_ID)
I exported the table, added data from another source that I need to bring into the table, and tried to reimport it. I populated the Contact_ID starting with the next sequential number.
I get an error message that says "Null value in AutoNumber field" for the last record in the spreadsheet (row 94). I have checked, it is the same format as all of the other rows.
I tried deleting that row, and I end up with the same result on row 93. It says there is an error on that line only, but it does not insert the other 90+ lines.
The format of the field in Access is a Long Integer, General number. In Excel it is configured to Number.
I have a table that has a PK that is an auto number (Contact_ID)
I exported the table, added data from another source that I need to bring into the table, and tried to reimport it. I populated the Contact_ID starting with the next sequential number.
I get an error message that says "Null value in AutoNumber field" for the last record in the spreadsheet (row 94). I have checked, it is the same format as all of the other rows.
I tried deleting that row, and I end up with the same result on row 93. It says there is an error on that line only, but it does not insert the other 90+ lines.
The format of the field in Access is a Long Integer, General number. In Excel it is configured to Number.