avijit Posted March 30, 2009 Share Posted March 30, 2009 How can i retrieve data from excel sheet to Mysql ? Can anybody have any idea , please explain ? Link to comment https://forums.phpfreaks.com/topic/151812-how-to-retrive-data-from-excel-to-mysql/ Share on other sites More sharing options...
taquitosensei Posted March 31, 2009 Share Posted March 31, 2009 save as a csv then use load data infile http://dev.mysql.com/doc/refman/5.1/en/load-data.html Link to comment https://forums.phpfreaks.com/topic/151812-how-to-retrive-data-from-excel-to-mysql/#findComment-797450 Share on other sites More sharing options...
Mark Baker Posted April 2, 2009 Share Posted April 2, 2009 How can i retrieve data from excel sheet to Mysql ? Use a library such as PHPExcel Link to comment https://forums.phpfreaks.com/topic/151812-how-to-retrive-data-from-excel-to-mysql/#findComment-799827 Share on other sites More sharing options...
fenway Posted April 3, 2009 Share Posted April 3, 2009 Or use the CSV engine type. Link to comment https://forums.phpfreaks.com/topic/151812-how-to-retrive-data-from-excel-to-mysql/#findComment-800305 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.