Restricted data entry

[Ssstacey]

Hi,

Im copying information from Excel to Acces. As I enter the information in fields in Access, this goes just fine. The problem is that sometimes I have to change the information I put in. So for example I first copied 10 record(cells), but now I discover that I have 20 records/cells. But Access refuses to let me enter more than ten. Does anywbody know why it does this and how I can fix it?
Thank u,
Stacey

 

[Ssstacey]

I dont know.. Actually, I dont know what is meant by "Duplicating keys". Can you give me an indication?
Stacey

 

[neileg]

It is normal for a table in Access to have a key field. This is a unique value that identifies that record from every other record in the table. Access prevents you from creating duplicates in this field, otherwise it's non-unique!

If you are trying to paste more records into the table that have the same values in their key fields as are already existing in the table, then this won't be allowed.

Excel does not support the concept of keys.