Failed to import table 'mytable', Column value 47 missing

// open the connection to db
// prepare insert statement
// set auto commit off
// prepare insert of records by batch
// executeBatch()
// when all is said and done, commit transaction