how to convert xls to mysql (2)

oo, i found this command from http://javakedaton.blogspot.com/2008/01/export-data-xls-ke-mysql.html:

LOAD DATA INFILE '/home/user/public_html/data/file.csv'
INTO TABLE jos_enindo_dir_company
FIELDS TERMINATED BY ','ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(field1,field2,field3,field4);


/home/user/public_html/data/file.csv is the full path of csv file
jos_enindo_dir_company is the name of mysql table
field1,field2,field3,field4 are field of mysql table that we will enter to xls.
be sure sum of field in xls is equal to sum of field in mysql table.

many thanks to javakedaton.