Take the 2-minute tour ×  I am trying to export an ODS file to
CSV, but when I import into phpmyadmin - I get "Invalid field
count in CSV input on line 1."  File (it has more than two lines
but the scheme is the same):  "Administração da Guarda Nacional
Republicana" "Administração de Publicidade e Marketing"
`id_profession` int(11) NOT NULL,   `profession` varchar(45)
DEFAULT NULL,   `formation_area_id_formation_area` int(11) NOT
NULL,   PRIMARY KEY (`id_profession`),   UNIQUE KEY
`profession_UNIQUE` (`profession`),   KEY
`fk_profession_formation_area1`
(`formation_area_id_formation_area`)  I never do something
similar, probably i need to specify the columns. the csv only
have one column and the table have three. In this case the file
input belongs to profession column  share|improve this question
Obviously, the data is in the wrong format, and required fields
are missing. You can't import it. –  nbt May 29 '11 at 18:27
andrewodendaal.com/… –  OMG Ponies May 29 '11 at 18:30 so, i
can't import a specific c