Re: Importing CSV files to MySql Db issue.

Chris Carter wrote:

I am not using spaces for closing. Every field is tightly packed with comma only. No spaces, no semicolon. The reason I used space is if I use space at least 3 or 4 fields get uploaded but not all. But we can ignore space for now as it happened earlier.

Then your issue will be a comma in your data. Header: Company Name, Name #1: Widget Co, Chris #2: Widget Co, New York, Chris #1 will work fine. #2 will be seen as "company name" -> "Widget Co" "Name" -> "New York" Extra data -> "Chris" at the end. Enclose your entries with something (" or ' or ~ or something else that's not going to be in your data). -- Postgresql & php tutorials http://www.designmagick.com/