+ Start a Discussion
rahul soni 20rahul soni 20 

what happens if some records do not meet the data validation cretaria when importing data?

Ajay K DubediAjay K Dubedi
Hi Rahul,

Validation rules ensure accurate data entry. Validation rules also catch errors at the data entry-level, and the mistakes never make it into your database.
If the data doesn’t satisfy the conditions that have been set, access won’t accept the input value.

Validation rules are more efficient than clearing up after the fact. 
To protect the validity of your data, you start at the foundation. 
The field’s data type will restrict input value to specify types of data.
The second line of action is the field table and validation rule, which restricts the input value conditionally.

Or we can simply say that-

"Import process fails only for the records with invalid data"

https://lnaim.blogspot.com/2018/07/when-importing-data-what-happens-if.html

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Ajay Dubedi
www.ajaydubedi.com