Import From Excel Into Table with an Autonumber Field

[rnutts]

Hi

I have a table called Table1 which has the address details for sites we work at.
I have an ID field (in table1, also primary key) which is Autonumber.
We have just won a contract to work on 3000 houses and to input this information would be very labourious
I have tried to import a test spreadsheet with an address on it, I have made sure all the columns in the spreadsheet match the fields in Table1, however I get an error message saying I am trying to import a Null value into an Autonumber field. I then tried to put a value into the column in the spreadsheet but again it fails.
I have tried importing the data to another table and then using an append query to update Table1, but I then get an error message saying 1 validation rules error.
I have looked for help and have tried removing the Primary Key temporarily.
Has anyone any other suggestions

Thanks

Richard

 

[neileg]

Not sure if you have existing numbers in the spreadsheet that you want to preserve. If you do, then make sure there is a unique integer value for each row. If you don't then don't assign a column in your spreadsheet to the PK field in Access. The autonumber will be populated.