data validation - parsing table with errors..

[dmeehanjr]

i'm working on a process where I will import data into a temp table, and then want to validate some of the data before proceding 'live' with it to apply updates.

I'd like to be able to write bad rows to separate table, with up to 2 error messages. The remaining (good) rows would be in a separate table

(Sample Data items to check would be; critical fields valued; valid dob; if this checked, then this date must be valued, etc..)

how could I do this in vba? - assuming that would be best approach -

thanks!
Don

 

[AccessMSSQL]

Well, what format are you importing from? Excel, csv, etc?

 

[dmeehanjr]

Will be importing from excel, residing in access table now.
thanks,
Don