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?
HELP..PHP code to import from an EXCEL file to mysql databse
Moderator: General Moderators
-
anirbanb2004
- Forum Newbie
- Posts: 23
- Joined: Sun Oct 15, 2006 4:21 pm
There's http://sourceforge.net/projects/phpexcelreader
But I can't tell you if it's any good - just found it via google.
But I can't tell you if it's any good - just found it via google.
-
anirbanb2004
- Forum Newbie
- Posts: 23
- Joined: Sun Oct 15, 2006 4:21 pm
Thanks...but is there any PHP code solution to this
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
What kind of solution is provided at http://sourceforge.net/projects/phpexcelreader ?anirbanb2004 wrote:Thanks..for your kind reply...but can you give a solution by php code?
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Code: Select all
fgetcsv();