Error "row xxxx doesn't contain data for all columns"

[Gary Nall]

Newbie might be an understatement for me. I've had MySQL for just a few days!

I'm trying to import a large csv file using the following statement:

LOAD DATA INFILE 'C:/Order_Download/orderdetail.csv'
INTO TABLE data
FIELDS terminated by ','
ENCLOSED BY '"'
LINES TERMINATED by'\n'
IGNORE 1 ROWS;

I'm getting this error: "Error Code: 1261. Row 2010 doesn't contain data for all columns"

Only one field ('ORDER')in my table is set as Not Null, which is my primary key. All others have the Default of NULL.

I've looked at the row in the csv file. It doesn't seem to be missing data and certainly isn't missing data in the Order field. So I'm at a loss for understanding why I'm getting this error.

Any ideas?