PHP code to import Microsoft Excel data to MySQL Database

Asked By gbong888 10 points N/A Posted on - 10/08/2011

I have a project where a file of class grades will be saved in an excel file.

The system should allow a user to upload via PHP script and save the data into the database via MySQL.

I need help with it please

• Status: Open
• Question Views: 1800
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PHP

Answered By albertfun 0 points N/A #89315

PHP code to import Microsoft Excel data to MySQL Database

I also had the same problem with my project earlier. There are lots of sample code in the internet for this problem. Some of them work and some of them do not. The code should be changed according to the type of the file that you are going to upload. Suppose you have excelled document with more than one tab.

Sometimes a PHP code will not work .It also different with how you arrange data sometimes.

However these are the solutions that I found and they work for me with few modifications.

Solution Source 1

Solution Source 2

I hope these will help you to overcome your problem.

Thank you.

About albertfun

Questions
0

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/10/2011
• Question Category: PHP