rudy.siregar Posted August 22, 2008 Share Posted August 22, 2008 Dear all, Can you help me here. I have a problem on how to read xls file and convert that cells of sheet into a table in my Database MySQL by PHP script. I have search alot, and still can't find the right script. Please help me... Thx. Regards, Rudy Link to comment https://forums.phpfreaks.com/topic/120804-read-xls-file-convert-to-database-mysql/ Share on other sites More sharing options...
cooldude832 Posted August 22, 2008 Share Posted August 22, 2008 I think in phpmyadmin you can upload a csv file right into a table but dont' quote me Link to comment https://forums.phpfreaks.com/topic/120804-read-xls-file-convert-to-database-mysql/#findComment-622721 Share on other sites More sharing options...
Hooker Posted August 22, 2008 Share Posted August 22, 2008 Can you show us a couple of records? i only ask because if it's tab delimited theres a very simple solution. Link to comment https://forums.phpfreaks.com/topic/120804-read-xls-file-convert-to-database-mysql/#findComment-622785 Share on other sites More sharing options...
Mchl Posted August 22, 2008 Share Posted August 22, 2008 I think in phpmyadmin you can upload a csv file right into a table but dont' quote me Yes you can. You can quote me on that. Also you can do it with MySQLs LOAD DATA INFILE statement Link to comment https://forums.phpfreaks.com/topic/120804-read-xls-file-convert-to-database-mysql/#findComment-622842 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.