CSV upload, once uploaded to a temp folder overwrite the existing database

[eluser]the_unforgiven[/eluser]
If i use $this->db->query(); it throws back this:

Code:

A Database Error Occurred

Error Number: 1136

Column count doesn't match value count at row 1

INSERT INTO wc_program (`JobRef`, `Area`, `Parish`, `AbbrWorkType`, `WorkType`, `Timing`, `TrafficManagement`, `Location`, `Duration`, `Start`, `Finish`) VALUES ("63830","Various","Various","SRTS","Safer Routes to Schools Schemes","Days","No Positive Traffic Management","Schemes Electrical Checks","8 days","09/06/2041","0000-00-00 63830","Various","Various","SRTS","Safer Routes to Schools Schemes","Days","No Positive Traffic Management","Schemes Electrical Checks","8 days","09/06/2041","0000-00-00 63230","Rural","Bramber","Micro","Micro-Asphalt Surfacing","TBC","Road Closure","Maudlyn Parkway","1 day","0000-00-00","0000-00-00 63230","Rural","Bramber","Micro","Micro-Asphalt Surfacing","TBC","Road Closure","Maudlyn Parkway","1 day","0000-00-00","0000-00-00 63231","Rural","Bramber","Micro","Micro-Asphalt Surfacing","TBC","Road ........ ......... ........ dots represent more lines theres 1700 records.