Uploading CSV files using phpMyadmin?

[Snicklefritz]

I have a csv file that I would like to upload using phpMyAdmin. The data consists of three columns of numbers. The first row indicates the names for each of the columns. I would like to take this information and substitute it for one of the tables in my zencart database. The file contains a lot of numbers which is why I want to upload the data with a csv rather than to input the same stuff manually.

The table I want to upload to has 8 columns. How do I get the data from the file to go into specific columns in the table? when I looked at the import options, I'm asked several questions:

(1) number of records to skip from the start: I'm not sure whether this refers to the file I am uploading, i.e. telling phpMyAdmin how many lines of header materials there is - or does it have something to do with where the file is placed within the table? i.e. which columns to put the information in

(2) fields terminated by ; Why is it asking me this when it's a csv file? the fields are separated by commas not by a semicolon. am I supposed to change this field?

(3) fields enclosed by "". They aren't enclosed by anything, so am I suppose to leave this blank?

(4) fields escaped by \ Not sure what this means

(5) lines terminated by auto
there's nothing at the end, just a return so I assume this field should be left alone.

(6) column names: is this referring to the names of the columns in the file? Or the names of the columns in the table where the numbers should go?


any help would be much appreciated.