i am using phpmyadmin and i am trying to import a file from ms excel. i keep getting this:
LOAD DATA LOCAL INFILE '/tmp/phpVldW6D' INTO TABLE `fans` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (`Invoice`, `Day`)
Unknown column 'Invoice' in 'field list'
is there an inside track to killing any learning curve??? any one with any experience with tis it would be appreciated.....