HI
I am pritty new with php but ok with it and what i am trying to do is making an inventory control system which is at time in xls file and want to transfer it to DB. what the problem is that i have never done this kind of advance php bfore and i have seen ppl do this and have no idea on what what commands to use so any hint would be nice...
also these xls file will update and will be uploaded alot so i need to make a perment solution not a 1 time solution; i can design all the html and basic code for php but have no idead how to take data in xls into db like what command i use to convert xls file...
Thanks :)
ashneet
0
Junior Poster
Recommended Answers
Jump to PostAs far as I know this is no easy way to convert excel file into sql db. Most people use software to convert it (do google search you will find plenty software around). I also come across similar question in other forum:
Jump to Post(i) If you're familiar with Java, the the Apache POI project allows you to easily read and write Office documents. If you can stick to just java, then I'd use this.
(ii) You can integrate java with your php code.
(iii) combining (i) and (ii), with a lot …
All 5 Replies
zippee
0
Posting Whiz in Training
ashneet
0
Junior Poster
leelee
11
Junior Poster in Training
ashneet
0
Junior Poster
leelee
11
Junior Poster in Training
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.