Invalid field count in csv input on line 1

it’s not a bug, it follow old excel csv pattern

ndal….kowe kie mbahas opo tho?

WOW thanks for the info, i uploaded a csv files successfully because of your advise. Great job!

ember jeng

hehehe, biasanya itu dari mysql lama ke mysql baru.

Thank you, thank you, thank you!

I’d been pulling out my hair for two hours until I stumbled upon your site.

Comma vs. semicolon… phew – I didn’t spot that. Amazing what grief one pixel’s difference can cause.

phpMyAdmin can go stuff its semicolon right up its last two syllables of the aforementioned punctuation mark.

Terima kasih banyak

thank you so much ,helped me a lot . .

Wow to think PHP used to not do this and does now.

This is stupid and the sheer number of posts i have seen of users with this problem i can’t believe they did soemthing so stupid just to maintain the old excel standard, clearly CSV stands for COMMA separated value.

thanks, it saved my time.

Sunny.

In my CSV file the fields were surrounded by ” (double quotes).
Please be sure there are no double quotes INSIDE THE FIELDS. Open your CSV file in Excel or scalc (openoffice suite):
– In scalc go to Edit > Find /Replace
– In Excel follow this steps: http://support.microsoft.com/kb/288291

Replace all the ” (double quotes) with ‘ (single quotes).

Another problem was with the DATETIME fields in MYSQL. In scalc select them all and right-click on them > Format Cells > and put “JJ-MM-DD UU:MM:SS” in the Format code box.

I’m only allowed to have in MYSQL first the year, then the month and then the day. For example “2009-12-29”.

After following these steps it worked for me.

And BTW, if there are still problems, open your CSV with Notepad or another text editor and check if every line has the right count of fields.

Wow, thanks for this… I was going insane 🙂 x

Hi,

its relay Great!

its helped me alot.

really Thanks….
Thanks….
Thanks….
Thanks….
Thanks….
Thanks….

vivek
CHPL pune

I have funded best solution

First of all open CSV file in Microsoft Excel and save it again with new name then

To solve this I had to do the following:

Import
Browse for your csv file.
Select CSV using LOAD DATA (rather than just CSV)
Change “Fields terminated by” from “;” to “,”
Make sure “Use LOCAL keyword” is selected.
Click “Go”

The above problem is probably due to the Windows default setting in Regional Settings (Control Panel) for the CSV file separator. It seems the USA and UK use different default values.

Another useful trick, when you’re having problems importing an Access table, is to open up the file in TextPad (or some other editor) and examine your data. You’ll probably find many errors. For instance if you have ” in your text field you’ll have to change it something else. I find that Access search and replace can be a little tempermental, so simply telling Access to replace the ” with a ^ doesn’t always work as expected.

Great job, I got this when trying to upload a csv database after editing it, I thought I broke it lol.

Thanks!

I’ve tried everything you said but only the first row out of 142 rows gets inserted. I also have this issue. I have 8 columns A thru H.
In the DB the first field is Product_ID and its set to auto increment. Even only after only one row being inserted the data in the CSV file does not transfer over to the same DB fields as they should (out of sync). Very frustrated.

Thanks a billion!

VERY helpful thanks. I kept getting errors! This worked perfectly.

Thanks again,
Mike