HELP..PHP code to import from an EXCEL file to mysql databse
Posted: Sun Oct 15, 2006 4:42 pm
Can any one help me doing this...
I want to write a code to upload a excell file datas into mysql table using php code(without using phpMyAdmin import).
What is I am thinking is converting the excell file into .csv.Then reading it and inserting in the table accordingly..
Perhaps it will work but definitely will take a lots of time and put a huge load on both the servers.
Is there any tricky methods?
I want to write a code to upload a excell file datas into mysql table using php code(without using phpMyAdmin import).
What is I am thinking is converting the excell file into .csv.Then reading it and inserting in the table accordingly..
Perhaps it will work but definitely will take a lots of time and put a huge load on both the servers.
Is there any tricky methods?