Trying to import them into a table isn't going to do that. You need custom code to read raw data and make a decision about whether it's the right data type or not. Once you have that code, then you can add any code needed to validate other characteristics of the data that might not be data-type related. That's why this kind of thing is ALWAYS custom work, and a ton of it, because you have to do it for every single field. The only way people generally do this is to treat ALL data as text and import it into a staging table, and then validate the data in the staging table with custom code to validate each individual field. As part of validation, you can create an Exceptions table that will identify the problem staging table records, and only import the good ones from staging. It's still a ton of work.