make a table of invalid records in access

B

Blenheim

I have imported some data into access into 3 different tables.
I have set up some validation rules and want to produce a table of all
records that don't meet these rules.
Is there an easy way to do this?
Ideally I would like to combine all rejected records into 1 reject table.
 
S

Steve Schapel

Blenheim,

Yes, you can use an Append Query to select all the invalid records and
then write them to the reject table.
 
A

aaron.kempf

if you were to use SQL Server you could drop failing records into a log
file.. it's called the 'Multi-Phase DataPump'.

MDB is for retards and lepers.. it doesn't have real ETL capabilities;
and it never will
 

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.

Ask a Question

Similar Threads

List all tables, including document structure 0
Outlook mail shared questions 0
Consolidation Table from Different Excel Tabs with Different Format 1
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
validation rule (for a record in a table) with dlookup 7
Using DSUM to get running total on a filtered form 0

Top