make a table of invalid records in access

[Guest]

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.

 

[Steve Schapel]

Blenheim,

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

 

[Jamie Collins]

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

Are you saying the OP must reproduce the validation rules in a query's
search condition? They would need to be rewritten because, unlike CHECK
constraints, the validation rule syntax is not SQL syntax e.g.
validation rule:

1 AND <5

I may be wrong but I get the impression the OP wants to know how to use
the validation rules without having to reproduce them in SQL.

Jamie.

--

 

[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