Welcome to WebmasterWorld Guest from 54.145.23.244

Forum Moderators: open

Message Too Old, No Replies

Excel File Upload Form and insert into MYSQL Table

     
2:17 pm on Jun 1, 2011 (gmt 0)

Preferred Member

10+ Year Member

joined:Dec 7, 2001
posts: 579
votes: 0


I know I can insert the contents of an Excel file into a MYSQL Table by using PHPMyAdmin.
However, I want to avoid my client having to access such a powerful area.

What I would like to achieve is a Web Form with a file upload field and php script that put the Excel contents directly into a Table. This form would live in the Password protected Admin area used by the client for the site CMS.

Please keep any suggestions to relatively simple terms so that I can understand.
Thanks in advance.
7:02 pm on June 1, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:Oct 3, 2007
posts:61
votes: 0


I just googled "parse excel with php" and found an ibm tutorial on how to do it with the excel file saved as xml, and a google code project that claims to do it for regular excel file. I think if you read the tutorial you would get a grasp of what is involved and perhaps the google code would help as well.

Hope that helps.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members