• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1208
  • Last Modified:

urgent - import xls into mysql database

Hi,

I want to upload an xls document and have php itterate through the rows and insert the data into a mySQL database.  can i get some help/examples/reference links?

thanks - Trevor
0
trevorhartman
Asked:
trevorhartman
1 Solution
 
merwetta1Commented:
I think this is exactly what you need (but it costs $67):
http://www.paggard.com/projects/xls.reader

Here is a free solution:
http://sourceforge.net/projects/phpexcelreader/

An easy approach to this problem would be to export the spreadsheet as a CSV file and then use PHP to parse that and load it into the db.
0
 
trevorhartmanAuthor Commented:
thanks, i'll try to get this working
0
 
madwaxCommented:
I just answered a similar question:

http://www.experts-exchange.com/Databases/Mysql/Q_21117228.html

Regards,
//madwax
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now