I ran into a snag when I was trying to update the zen_products table in the database. I have a updated csv saved as a comma delimited file. I am trying to update the table with the new data and I think I have tried it just about everyway I can think of. I want to update the existing database table with the csv file.
I am not sure what I am doing wrong but I have used the import file feature under the import tab and I have 3 formats available (two that may apply to what I am attempting).
First is the CSV then there is the CSV using LOAD DATA.

First I selected CSV with the options "Replace table data with file" selected and the fields terminated by a "," (comma). Then I removed the quote from the "Fields enclosed by" and then I added a "n" to the "\" that is in the "Fields Escaped by" field. I get an invalide field count in CSV input on line #1 ( I believe I put in column names seperated by commas.

When I do this do I want to keep the column names in the csv file or do I need to delete them?

I appreciate in advance any assistance that anybody can give me.

INFORMATION:
Using Zen Cart 1.3.8
phpMyAdmin - 2.11.9.5
MySql - 5.1.30



Thanks,
-W