N/APosted 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
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.