how can i import excel data into mysql

[pcoder]

i need to import Excel data into Mysql database. How can i do it. Is there any utility or any script can do it. Thanks in advance.

[ronverdonk]

Look at the following thread converting Excel to MySQL using PHP in this forum.

Ronald :cool:

[catacaustic]

The simplest way to use Excel imports and exports with PHP is to use the PEAR Excel functions. I've just finished working on a project where I've had to export to Excel directly from PHP, and another developer produced the import script, and it's all pretty easy wen you use this.

[makana]

The simplest way to use Excel imports and exports with PHP is to use the PEAR Excel functions. I've just finished working on a project where I've had to export to Excel directly from PHP, and another developer produced the import script, and it's all pretty easy wen you use this.

hiii can u please post or send me the code for pear excel function as i am new to this so could u please help me out in it thanks a lott in advance even u can mail the code to my id [e-mail] thanku once again

[jx2]

php do not have this function built in so you need to write it on your own or yous third parties resorses e.g see this website

regards
jx2