mike1 Posted August 9, 2007 Share Posted August 9, 2007 i have developed a website using php and mysql.The problem is that i want to know how can i import data using the excel sheet into mysql.i mean i have a link in the admin section where the admin will select the file and upload it.then all the data in the excel sheet should be pumped into the mysql database ???.Any help would be greatly appreciated. thank you mike1 Link to comment https://forums.phpfreaks.com/topic/64066-read-data-from-excel-using-php/ Share on other sites More sharing options...
HuggieBear Posted August 9, 2007 Share Posted August 9, 2007 You could export the excel spreadsheet as a CSV file then use fgetcvs() or alternatively you could probably use COM objects. Regards Huggie Link to comment https://forums.phpfreaks.com/topic/64066-read-data-from-excel-using-php/#findComment-319297 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.