import excel to mysql

import excel to mysql

El Forum
Guest

#13

06-24-2009, 06:24 AM

[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 16

after 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.

Messages In This Thread

import excel to mysql - by El Forum - 06-23-2009, 01:46 PM

import excel to mysql - by El Forum - 06-23-2009, 02:11 PM

import excel to mysql - by El Forum - 06-23-2009, 02:15 PM

import excel to mysql - by El Forum - 06-23-2009, 03:00 PM

import excel to mysql - by El Forum - 06-23-2009, 03:04 PM

import excel to mysql - by El Forum - 06-23-2009, 03:05 PM

import excel to mysql - by El Forum - 06-23-2009, 03:11 PM

import excel to mysql - by El Forum - 06-23-2009, 03:14 PM

import excel to mysql - by El Forum - 06-23-2009, 03:16 PM

import excel to mysql - by El Forum - 06-23-2009, 03:17 PM

import excel to mysql - by El Forum - 06-23-2009, 05:42 PM

import excel to mysql - by El Forum - 06-24-2009, 06:24 AM

import excel to mysql - by El Forum - 06-24-2009, 07:15 AM

import excel to mysql - by El Forum - 06-24-2009, 07:57 AM

import excel to mysql - by El Forum - 06-25-2009, 12:02 AM

import excel to mysql - by El Forum - 07-28-2009, 07:08 AM

import excel to mysql - by El Forum - 07-28-2009, 08:19 AM

import excel to mysql - by El Forum - 07-29-2009, 04:55 AM

import excel to mysql - by El Forum - 07-29-2009, 05:55 AM

import excel to mysql - by El Forum - 07-29-2009, 06:42 AM

import excel to mysql - by El Forum - 07-29-2009, 06:52 AM

import excel to mysql - by El Forum - 07-29-2009, 07:09 AM

import excel to mysql - by El Forum - 07-29-2009, 12:20 PM