Problem importing csv file

Databases
1

Hi all,

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!

2

what were you using to import the file?

3

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!) :slight_smile: