Flat file to sql conversion problem

Can you post the DDL (CREATE TABLE) statement of the table you're trying to import into?

Also, since your textual dates are not formatted in ISO yyyy-mm-dd, it's possible you have a value that's interpreted with the wrong setting, e.g. D/M/YYYY rather than M/D/YYYY. That could overflow a month value, for instance.