How to display records that violate validation in Access insert query?

Using Access 2007. I'm trying to insert records into a table with data validation rules, and I'm getting the error message that Access didn't add "1543 record(s) due to validation rule violations." Is there 开发者_开发知识库any way to make Access display the records that failed validation, so I can figure out which values are breaking my validation rules? I looked all over Google but couldn't find anything to accomplish this.

Perhaps you could copy the records from the results of the query, then paste into your target table. Access will create a new table called something like Paste_errors which would contain the records which failed to insert.