Instead of appending your csv file to a table you might try importing it and then appending the resulting cursor to your table. This would highlight any datatype conflicts.