Import Excel File into MySql Database

[transfield]

Hello,
I want to import either an Excel file or CSV file(whichever is easier) into a MySql database. I've done this with text files using the code below. However, this code does not work with Excel or CSV files. Is there any way to modify this code or are there any alternative codes to do the same thing?

Thanks a lot for your advice.

$query = "LOAD DATA LOCAL INFILE '/home/website/domains/website.com/public_html/commercial.txt' INTO TABLE commercial(date_updated,classification,name,address_1,address_2,address_3,address_4,address_5,address_6,phone_1,phone_2,phone_3,telex,email,contact_1,contact_2,contact_3,url,remarks)";
mysql_query($query) or die(mysql_error());

Additional Info:-
My webhost does not allocate much memory to me so any memory intensive code will not work.

[pete_bisby]

I think there are additional criteria you can include with the LOAD DATA command in MySQL.

Have a look at this URL on the MySQL website, and it should give you a better understanding of the SQL command - look towards FIELDS TERMINATED BY, ENCLOSED BY, ESCAPED BY, etc.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

[transfield]

Thank you for your reply, pete. I will check it out. I appreciate your assistance on this matter.