Why is pasting from excel proving to be so difficult?  I get a gamut of error messages no matter what I do.
If i just copy the specific cells, I get this error--- "The value you entered isnt valid for this field"
If I try to copy a whole row, I get this error--- "Too Many Fields Defined"

These errors make sense as a sum of the words, so ive made sure that what Im pasting is formatted identically to the  fields in Access.  Im at a loss.  please help..

---

Reply from Alex Hedley:

Do the columns you have in your Excel workbook match the fields in your Access Table?
They need to be the same order.