import data from excel file [mydata.xls] into mysql table

arshigill

I want to import data from excel file [mydata.xls] inot mysql database table but unable to solve this problem.
I have searched google and find an example of importing of CSV excel file.
But when I modify it for my own requirements it does not work.
Please help me with an example to import data in colums in exel file into mysql table columns.

Thank
PHP Lover

ronverdonk

Welcome to Bytes!

Then show the piece of code that does not work. You are not just asking for a simple few lines sample, you ask for a lot of code.

So show the culprit code (and show it within the appropriate code tags).

Ronald

import data from excel file [mydata.xls] into mysql table

re: import data from excel file [mydata.xls] into mysql table

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about