CSV import to MySQL via phpMyAdmin

[orydian]

Okay, this is driving me round the bend. I'm trying to import a single column/field into MySQL.

CSV looks like this...

"Name A",
"Name B",
"Name C",
and so on.

I'm trying to import it into a table with a field called 'name'.

I locate the correct table via phpMyAdmin and click to import the file with the following settings...

Fields terminated by = ,
Fields enclosed by = "
Fields escaped by = \
Lines terminated by = auto
Column names = name

Then I click Go, but I always get a "Invalid field count in CSV input on line 1." error.

I'm very knew at this, and I'm clearly doing something wrong, but I've no idea what the problem is. If anyone could help with this, I'd really appreciate it.

ory.

[sarahA]

Set lines terminated by as /n/r and open the file you're importing and check there are no extra columns (ie. there's not any commas if you only have one column), and that there are no blank lines

[JasonD]

You have a comma at the end of the line so it will want to insert an empty value into a second column.

Remove the commas from the file, or add a column to fill with the nothing and remove it when you are done.

[orydian]

Cheers guys. I'll try it out.

ory.

[orydian]

Yes! Removing the commas did the trick.

Thank you both very much indeed.

ory.