Cannot Append Data to Access Table

[Gwen]

I have a Life-To-Data table of data that I append new data to each month. I
import the Excel spreadsheet and append it with no problems for years. A
coupel months ago, the initial table was too large for Excel so it was dumped
to an Access table. I am trying to copy and append it to my table but keep
getting the message...

Microsoft Office Access was unable to append all the dat to the table.
The contents of fields in 0 records were deleted and 0 records were lost due
to key violations.

If I click "yes" to continue anyway it does not append the data. I have
tried to make sure every field has the same properties as the destination
table but I have had no luck. I'm running out of ideas. Any suggestions?

 

[Allen Browne]

See:
Why can't I append some records? Trouble-shooting imports
at:
http://allenbrowne.com/casu-19.html