Another reason for failure to insert is that your database has a constraint (requirement) that is not being met with the record that you are trying to insert.
Is there a required field not being populated?
Is there a field that you are trying to insert the wrong data type?
Is there a field that requires specific data (perhaps a link to another table) that you are not populating with valid data?
Just a few things to consider.