Data error type mismatch help

[gd4114]

I hit this error almost everytime I try to automate a datadump and one of the fields may have a different data type than expected. 

Need to automatically detect data types, but also help user pinpoint which column is throwing the error and is mismatched. 

I have sheets with many columns and it is very tedious to figure out which one is causing the issue. 

Error returned: 'OLE DB or ODBC error: [Expression Error] The key didn't match any rows in the table