2 Replies - 776 Views - Last Post: 11 June 2008 - 02:58 PM Rate Topic: -----

#1 jyothi123  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 11-June 08

Reading from excel and inserting it into the DB through PHP script

Posted 11 June 2008 - 02:07 AM

Reading from excel and inserting it into the DB through PHP script. Is this possible? i wanted to know that and if yes could i get the links from where i can take the help? :)
Is This A Good Question/Topic? 0
  • +

Replies To: Reading from excel and inserting it into the DB through PHP script

#2 akozlik  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 90
  • View blog
  • Posts: 797
  • Joined: 25-February 08

Re: Reading from excel and inserting it into the DB through PHP script

Posted 11 June 2008 - 01:23 PM

View Postjyothi123, on 11 Jun, 2008 - 05:07 AM, said:

Reading from excel and inserting it into the DB through PHP script. Is this possible? i wanted to know that and if yes could i get the links from where i can take the help? :)


Yeah it's pretty easy. All you need to do is export your Excel file as a CSV or Tab Separated, then write the script to process each row. It's not too bad, just some while loops.
Was This Post Helpful? 0
  • +
  • -

#3 akozlik  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 90
  • View blog
  • Posts: 797
  • Joined: 25-February 08

Re: Reading from excel and inserting it into the DB through PHP script

Posted 11 June 2008 - 02:58 PM

I actually just submitted a tutorial to the PHP Tutorials section on this very topic. Once it's approved by the moderators you should be able to view it. I hope it helps you.

This post has been edited by akozlik: 11 June 2008 - 02:58 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1