Welcome Guest, Not a member yet? Register   Sign In
importing excel data to the mysql database
#1

[eluser]Unknown[/eluser]
Am new with code igniter and i would like your help guys. For a week now i have been trying to crack how to import excel data into the database. For instance i have an excel file with uid, username and mobile fields to be imported to a mysql table with the same fields.what code do i put into the controller, view, model and helper folders for the data to be imported into the database. Guys i really need this to make it work.
#2

[eluser]vitoco[/eluser]
I don't know a way to "import" an excel file into mysql, but you can read the sheets with the
"php excel reader" library ( http://code.google.com/p/php-excel-reader/ ) and make the inserts into the db.

Saludos
#3

[eluser]danmontgomery[/eluser]
http://lmgtfy.com/?q=import+excel+data+into+mysql
#4

[eluser]vitoco[/eluser]
[quote author="noctrum" date="1288034555"]http://lmgtfy.com/?q=import+excel+data+into+mysql[/quote]

JAJAJJAJA....great!!




Theme © iAndrew 2016 - Forum software by © MyBB