Added as a solution as suggested.
In your insert statement just specify the number of columns you want to insert. You don't have insert data into every column.
Below is pseudo code that will give you an idea. It is taken directly from MSDN
INSERT INTO target [(field1[, field2[, …]])] VALUES (value1[, value2[, …])