Import Excel data to MySQL Front

Anyone know how to import excel to Mysql front?

i have some listing data in excel, and i wanna import the data to MySQL front db...

thanks thanks:)

Here's what I did to do it:

I saved the file as a CSV and then used fopen() to read the file and then used fgetcsv() and a while loop to write each record into the database.

There are various methods of completing this task and this is the method I used. Hope this atleast gives you somewhere to start.

Links:

http://php.net/manual/en/function.fopen.php  You'll be using fopen() first to open the file

http://php.net/manual/en/function.fgetcsv.php  You'll then be using fgetcsv to work with the open file

EDIT:

This was posted in the PHP forum to start with so I'm providing you with the PHP functions.