Appending data from a transferred excel spreadsheet

[Data]

I have transferred data from excel into a temporary table using a macro built into a form. This form should call up 4 fields, "autonumber", "Display Number", "Display Cost", and "Assembly Cost" from a separate permanent table after an append query is run. The Temporary table contains all of the fields except "autonumber". The Permanent Table has all four fields. Each time the transfering of the data is done from excel to the DB, the old data is deleted from the temp. table via a delete query. My problem is within the append query. I can't get it to append only the most current record specified in the form. Within the query, I have tried using criteria such as "[Forms]![Name of my Form]![autonumber]", but the error I keep getting is that the query couldn't append the values because of a "key violation". I hope all of this made sense to someone, if it doesn't well...

 

[Norie]

Is the Autonumber field actually of Autonumber data type?

Is it the primary key of the Permanent table?

If it is you can't append to it as it is automatically created. Do you actually want to keep the autonumbers from the Excel spreadsheet?

If you do then you'll have to change the data type of the autonumber field.