Alex, remember: you can see your computer. You know what actions you
have taken. We do not.
If - and I'm strictly guessing here! - you are running an Append query
and some records are being rejected because of key violations or some
other error, then the rejected records aren't "put" anywhere. They
should still exist in your original data source, and you can run an
appropriate query to determine why they're not being added. What's
"appropriate" depends on the nature of the error, and the structure
and contents of your tables. We don't know what these are of course!
John W. Vinson[MVP]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.