Append Query Problem

[ssworthi]

I am trying to convert my .mdb data base to the .accdb format and when I try to run a simple table to table append query and I am getting "Max can't append all the records in the append query. Max Set 0 field(s) to null value due to a type conversion failure due to key violations"
I have never seen this before. This db will eventually feed SQL Server and there are a lot of primary keys set up which one is "name" and the only other field that is being appened is id. Any help would greatly be appreciated as always.

 

[boblarson]

1. A field should not be named "NAME" as that is an Access Reserved Word (and one of the WORST for using as an object or field name).

2. Converting to an ACCDB should be able to IMPORT the table - not having to append the data instead.

3. The primary key should be on ID and not on ID and Name.

 

[ssworthi]

Thanks so much. I changed the name of the field to EE_Name in both the imported file and the table I'm trying to import to and again am getting the "Max was unable to applend all of the records, the content of the fields in 0 records were deleted and records were lost due to key violations" Should I take off the primary key for name? Thanks so much.

 

[boblarson]

Why are you appending? Shouldn't you just be importing the entire table?

 

[ssworthi]

I am importing an excel file and in the import options it asks if I want to import to a new table, append to an existing table and that is what I am trying to do. I have also imported to a new table and tried to append table to table and am still getting the error. Thank you.