How do I export data from an Excel sheet into a MySQL database? Is data to be inserted into different tables instead of a single table using the upload button from the PHP/HTML page?

First make sure you save your Excel file as CSV. Consider that you have data for serial no, name and course info. You wish to put them into tables. Here is a simple example code to do that: $source = fopen('student-info.csv', 'r') or die("Problem open file"); while (($data = fgetcsv($source, 1000, ",")) !== FALSE) { $sno = $data[0]; $name = $data[1]; $courses = $data[2]; mysql_query("INSERT INTO `stable` (`sno`,`name`) VALUES ('".$sno."','".$name."') "); mysql_query("INSERT INTO `coursetable` (`sno`,`courses`) VALUES ('".$sno."','".$courses."') "); } fclose($source);

LOAD DATA LOCAL INFILE 'C:\\temp\\yourfile.csv' INTO TABLE database.table FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (field1, field2); this may help

Export the file to a CSV. Then Upload if the table matches the structure of the CSV, you're done.If not, you'll need to upload the xls and use a server side language to parse it out and save it.