Import Excel data to MySQL Front

[lilywong]

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:)

[Skewled]

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.