Page 1 of 1

HELP..PHP code to import from an EXCEL file to mysql databse

Posted: Sun Oct 15, 2006 4:42 pm
by anirbanb2004
Can any one help me doing this...
I want to write a code to upload a excell file datas into mysql table using php code(without using phpMyAdmin import).

What is I am thinking is converting the excell file into .csv.Then reading it and inserting in the table accordingly..

Perhaps it will work but definitely will take a lots of time and put a huge load on both the servers.

Is there any tricky methods?

Posted: Sun Oct 15, 2006 4:49 pm
by volka
There's http://sourceforge.net/projects/phpexcelreader
But I can't tell you if it's any good - just found it via google.

Thanks...but is there any PHP code solution to this

Posted: Sun Oct 15, 2006 4:53 pm
by anirbanb2004
Thanks..for your kind reply...but can you give a solution by php code?

Re: Thanks...but is there any PHP code solution to this

Posted: Sun Oct 15, 2006 4:55 pm
by volka
anirbanb2004 wrote:Thanks..for your kind reply...but can you give a solution by php code?
What kind of solution is provided at http://sourceforge.net/projects/phpexcelreader ?

Posted: Sun Oct 15, 2006 10:27 pm
by Ollie Saunders

Code: Select all

fgetcsv();