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 Quote 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'. Quote 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 Quote 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) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.