narendra12345 Posted May 9, 2007 Share Posted May 9, 2007 Hi, This is Narendra. I need help regarding importing excel file into mysql database.I am using PHP 5.0.2, mysql 4.2.13. I need code for importing excel file into mysql database and what will be the steps for it. Pls Help Me. Thanks and Regards, Narendra Link to comment https://forums.phpfreaks.com/topic/50654-code-for-importing-excel-file-into-mysql-database/ Share on other sites More sharing options...
trq Posted May 9, 2007 Share Posted May 9, 2007 You will need to look into COM to open an excell application object. Actually using com is outside the scope of php, php just provides an interface to it. You might try googeling 'open excell through com'. Link to comment https://forums.phpfreaks.com/topic/50654-code-for-importing-excel-file-into-mysql-database/#findComment-248977 Share on other sites More sharing options...
narendra12345 Posted May 10, 2007 Author Share Posted May 10, 2007 Hi, This is Narendra. I need help regarding importing excel file into mysql database.I am using PHP 5.0.2, mysql 4.2.13. I need code for importing excel file into mysql database and what will be the steps for it. Pls Help Me. Thanks and Regards, Narendra ---------------------------- i have found trial version in www.excelparser.com for importing excel file into mysql database.I am not getting how to use it. Can you explain the procedure in step by step. Thanks and Regards, Narendra 10th May Link to comment https://forums.phpfreaks.com/topic/50654-code-for-importing-excel-file-into-mysql-database/#findComment-249624 Share on other sites More sharing options...
MadTechie Posted May 10, 2007 Share Posted May 10, 2007 OK your best option is to save as CSV and use that file, i wrote a excel importer to mysql it took about amonth and works but still isn't 100% EDIT or use coms (easier) Link to comment https://forums.phpfreaks.com/topic/50654-code-for-importing-excel-file-into-mysql-database/#findComment-249676 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.