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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
anirbanb2004
Forum Newbie
Posts: 23
Joined: Sun Oct 15, 2006 4:21 pm

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

Post 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?
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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.
anirbanb2004
Forum Newbie
Posts: 23
Joined: Sun Oct 15, 2006 4:21 pm

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

Post by anirbanb2004 »

Thanks..for your kind reply...but can you give a solution by php code?
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

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

Post 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 ?
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

Code: Select all

fgetcsv();
Post Reply