Cannot append but can copy n paste into table

[machumpion]

I have a list of new customers that I want to add to my Customers table. The primary key is Name. I cannot add the names from the new customer list with an append query, but when I manually copy and paste them into the Customers table directly it works.

How come this is happening?

edit:i figured it out via trial and error
another numeric field in the same table defaults to 0. When I removed the default value, all the customers appended in the append query. I'm not sure why though.

 

[Ranman256]

you shouldnt use name as primary key . People have the same name. This is what autonumber is for if you dont have a unique identifier.

make sure you didnt set any other fields to be indexed unique. this could stop appends too.