Import an Excel file into MySQL

30th Jul 2006

After uploading the Excel file to your web space, use this SQL:

load data local infile '/complete/path/to/your_csv_file.csv' into table table_name
fields terminated by ','
(field_1, field_2, field_3, field_4)