Import the data from excel file
I want to import all the data of a excel file to import in the database (PHPMyAdmin) table of of format id, name, reg_no, Roll_No, sub1, sub2, sub3, sub4, sub5, sub6, sub7, sub8, sub9, sub10, sub11, sub12, sub13, sub14, sub15, sub16 and remarks
These are the heading of that table, i have all the record of respective table. How i m able to import such data.
If your database structure is same then you can directly import data from excel file to MySQL. You just need to click on Import tab and many options are present there.
But if you need changes in that then you have to write a script for that.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)