load data infile statement

load data infile 'c:/bse/EQ060307.CSV' into table bse2006 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' ignore 1 lines

i get error
1262

i admit that there are fields in my csv with extra columns which i dont wish to have in my datebase .how can ignore a column

 

is there any software like navicat which dows things by wizard and shows us the command also