Import .xls file into a mysql database
I have a .xls file that i would like to import into a mysql database, I am ok creating the mysql table _temp in my webspace and try this code in mysql:
LOAD DATA INFILE
INTO TABLE _temp
FIELDS TERMINATED BY ',' IGNORE 1 LINES;
[Err] 1261 - Row 1 doesn't contain data for all columns
Any ideas most welcome.