Member Avatar for jacksantho

Hi, Guys

Could anyone tell me how to import MsExcel data into MySQL using PHPExcel. I want to make an upload system for my users. They want to upload their data which is in Ms Excel format into MySQL databases...Please teach me how to do that...

And I appreciate your answer so much ...

  • 2 Contributors
  • 1 Reply
  • 143 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by vimalnath53
Member Avatar for vimalnath53

First, you need to read the data present in the excel using PHP excel reader.
(get help from this link:http://forums.digitalpoint.com/showthread.php?t=24351)

There will be a zip file(excelRead.zip). download and paste it in www folder to get idea of how it works.

And,once you get the data from the excel using php, it's easy to insert the data into mysql function available in php.


Hope this helps.!!!
If not reply, will do my favor...
Regards..
:-)

Edited by vimalnath53 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.