Error Message-Microsoft access was unable to append all the data to the table

While uploading the excel files into access table I am getting the following error message...

Microsoft access was unable to append all the data to the table ...
contents of fields in 1 record(s) was deleted...

May I know why am I getting this message and how to fix the problem...

Thanks
redgreenredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

proziathCommented:
In the past whenever I a similar message it was because there were two or more records that had the same primary key value. Sometimes the error message tells you a bit more information about the error.

I would suggest doing the same operation and comparing the original excel file with the access table to see which record was refused. Having found the record, I would would examine it to see if there is a problem with the primary key filed or fields.

By the way, have you any primary keys or indeces defined in your access table?
0
jadedataMS Access Systems CreatorCommented:
Hey redgreenred!

  Hopefully this will be a field where the data is always entered.  Find the record with the blank field and you find the offending bit of info.
  remember, it did not block the record append, it only deleted the field content.

  I have seen this on appends or updates where a non-date is being forced into a data datatype field.
  Other mistyped data may cause this but dates are the most prevalent in my experience.
 
  Search the spreadsheet for data that is in columns that will violate datatype restrictions in the table you are appending to.

regards
Jack
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ornicarCommented:
----------------------------------------------------------------------------------------
This question has been abandoned and needs to be finalized.
 You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
  If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ornicar
Cleanup Volunteer

---------------------------------------------------------------------------------------------
0
jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: jadedata {http:#9799183}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.