I am trying to upload a csv file (sample attached), to a simple two column table in mysql. Im getting the "Invalid field count in CSV input on line 1." error.
The two fields are layed out as follows: -
Field Type Collation Attributes Null Default Extra Action
location_code varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
location_name varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Does anyone have any idea where Im going wrong? thanks!
what were you using to import the file?
Hiya there, thanks for your reply. I found the problem in the end, only I cant remember now what I did to fix it (thats not good!)