How are you entering the data into the database?
What constitiutes a rejected record?

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]