import excel to mysql

[eluser]jedd[/eluser]
[quote author="Monisha" date="1248889363"]again thanks for reply... this is not a case what ur getting.
let me explain my query.. I dont want to use import function which is already provided in MSSQL or MYSQL. I want to import an excel file like using file upload button and by coding in codeigniter i need to import this excel data in database. Right now im trying with CSV and Excel. [/quote]

There are two parts to this process.

The first is getting the file from the client (web browser) to the server. The second is parsing that file, using PHP, and feeding it into your preferred database (Microsoft SQL or MySQL by the sounds of it).

I don't know why you 'don't want to use import function which is already provided' - as using an already provided function to do the hard bit is very attractive (it's already provided, being the primary attraction).

The first bit - uploading a file - is painfully easy, and is well covered in the [url="http://ellislab.com/codeigniter/user-guide/libraries/file_uploading.html"]CI User Guide[/url] and even more excruciatingly explained in any number of forum threads.

I suspect that many of us are confused by your apparent confusion with this fairly straightforward process.