One suggestion that i can give you is that whenever you bring data from the "outside" is to dump all the data in tables that your application don't use and then use a `Stored Procedure` to import the actual data in your production tables.
this is useful because you work with local data when you copy in the production tables, also you can do data manipulation or conversion using the db itself and not an external programs, so it's less likely that you import bad data.
One advice if you go this route is to use a couple of column in this new table, PROCESSED to check if is processed or not, or it happened some error (think like `Yes`, `No` or `Error` ) and a field to print the error description and another to see which process processed the row last.