I wanna import my excel or csv files into my mysql database.

[eluser]Unknown[/eluser]
I wanna import my excel or csv files into my mysql database.

Is there anyone who tell me how to do.and paste the code here?

Thanks in advance...

[eluser]Unknown[/eluser]
do you have the privileges to install some app like phpmyadmin in your server?

[eluser]GSV Sleeper Service[/eluser]
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

[eluser]Unknown[/eluser]
I mean is there any CI library can import excel files to database....

[eluser]mironcho[/eluser]
I don't know about CI library, but take a look at:

phpExcelReader
fgetcsv function

CSV actually is easy to parse without any additional tools...

[eluser]MadZad[/eluser]
Ditto mironcho's comment - if you can get CSV input, that would be waaaaaaaaaaaaay easier than Excel input.

We already had a copy of Excel Parser Professional by Algera purchased, so that's what I used for reading Excel format, with good results.

[eluser]obobo[/eluser]
Also check out simple cvs import

I just finished using it on a project and it worked fine.
Just upload the php file and the .csv to your server,
edit the php file with your db info and the name of the csv file
run the script and you're done.

[eluser]MadZad[/eluser]
Oh yes, and perhaps the first thing to decide is just how militant you want to be about scrubbing the input. Who has access to the upload utility, and could they have a value in one of the cells like "'); drop database; --"? Always beware of little Bobby Tables.

[eluser]MadZad[/eluser]
For what it's worth, years later we're leaving Excel Parser Pro with our upgrade to PHP 5.3 and CI 2.0, due to the Zend Optimizer complication.

Going with PHPExcel.