homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Excel File Upload Form and insert into MYSQL Table

10+ Year Member

Msg#: 4320534 posted 2:17 pm on Jun 1, 2011 (gmt 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.



5+ Year Member

Msg#: 4320534 posted 7:02 pm on Jun 1, 2011 (gmt 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.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved