+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: import excel to mysql (/showthread.php?tid=19954)
import excel to mysql - El Forum - 06-23-2009
[eluser]Dam1an[/eluser]
Well, we do try
Ad it turns out using the quick reply really does make you faster lol
import excel to mysql - El Forum - 06-23-2009
[eluser]ray73864[/eluser]
or you can use MySQL's native 'LOAD DATA INFILE' which can take the csv file directly to the DB and insert/update records as required. It works a lot quicker than even trying to build up the query.
import excel to mysql - El Forum - 06-24-2009
[eluser]umefarooq[/eluser]
well library is working really fine im able to get my desired data but now facing more problem is that excel file also has address which already separated by commas for example
Code:
Gold Centre 1st Floor, Office No 16after exporting to CSV file address is closed in double quotes like
Code:
"Gold Centre 1st Floor, Office No 16"but when this data come to CSVReader library that is also splitting address also how can i avoid to split address between double quotes.
import excel to mysql - El Forum - 06-24-2009
[eluser]tomcode[/eluser]
You have to use another sign as delimiter (
in the csv files and in the library
import excel to mysql - El Forum - 06-24-2009
[eluser]TheFuzzy0ne[/eluser]
I think a tab would probably be the smartest delimiter to use.
import excel to mysql - El Forum - 06-25-2009
[eluser]umefarooq[/eluser]
well ; work really fine the only thing is client has to change the delimiter from the system regional settings
import excel to mysql - El Forum - 07-28-2009
[eluser]Monisha[/eluser]
Well.. I read this post from starting..
can anyone tell me about excel file import to mssql or mysql database..??
I didn't get any direct library or plugin.
please answer if somebody know about this..
Thanks in advance
import excel to mysql - El Forum - 07-28-2009
[eluser]TheFuzzy0ne[/eluser]
Are you wanting to import a CSV that represents the actual table, or just extract some of the data, and insert that into the database?
import excel to mysql - El Forum - 07-29-2009
[eluser]Monisha[/eluser]
My actual requirement is to import excel or CSV to MSSQL database. not to extract only...
any idea...???
import excel to mysql - El Forum - 07-29-2009
[eluser]TheFuzzy0ne[/eluser]
http://lmgtfy.com/?q=import+csv+mysql