Hi,
I am importing xls files into Access and require certain validation checks on these fields. What I would like to do is import all of the data initially to be validated, have the invalid entires placed in a table and the valid in another. Access will notify me that invalid entries exist.
Is there a way I can have the invalid rows (found from the validation) placed into another table immediately (allowing me to easily see which data is invalid and giving me the ability to manually fix)?
Any help or suggestions on the topic is appreciated.
Thanks!