please i need code in php that i can import an excel file and to convert it in text tab or comma limited file + import data in mysql with some query
i have searched and i cant find anything any thought

thanx!!!

kgougakis,

I have come across this project on source forge which may assist you:

sourceforge.net/projects/phpexcelreader/

kgougakis, you can of course just save the excel file as a csv file. I found this nice app here that works great.

http://www.sqldbu.com/eng/sections/tips/mysqlimport.html

Also, check this little script here.

http://www.cyangarden.com/development/php/csv2mysql.php.txt

Also, for something really easy, I looked into http://www.comdevweb.com/csvdatatool.php.

I have a client that wants to update her database from a microsoft works database (bangs head against keyboard) and this looks like the easiest way to do it. Kind of expensive and only allows one license per website, but, has an a backup feature and pretty simple to use.

If anyone else can think of an easier way to do this, please post!

thank you alot recipher,p.davies you cover my request