/Solved ERROR – phpMyAdmin – Invalid field count in csv input on line 1

Solved ERROR – phpMyAdmin – Invalid field count in csv input on line 1

ERROR: phpMyAdmin – Invalid field count in csv input on line 1

 

The csv file was generated using Microsoft eXcel 2010.  Fields are separated by < , > while php importer expects < ; >

Error while importing a csv file dataset into phpMyAdmin:  “Invalid field count in csv input on line 1″

Don’t worry! phpMyAdmin is smart enough and is able to import your data from csv

How to fix it:
Use the settings below

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