Inserting Excel data into MYSQL

Hey I need help

i'm still pretty new to PHP. I need to take the data stored into a excel spreadsheet and insert it to a mysql database. Can anyone help me with this?

Thanks

 

Install phpmyadmin it does all this stuff for you.

 

thank for the info, I will look into it.


but i'd rather be able to code it into my site.

 

Believe me, if you use php/mysql you need phpmyadmin. The stuff it does would be very hard to progam into your own site without loads of bugs.

 

You can export the data from excel into CSV format. Then you can use phpMyAdmin to import it to the database. Or you can use the SQL command
LOAD DATA INFILE. You can get more info on it here:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

Its syntax is somewhat like this:
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata;
or
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata ( id,fname,lname,email);

Thomas

 

thanks for the help.