I just tried an import of 34 rows. The import threw the column count mismatch error starting at row 16. I trimmed the first 15 rows out and tried again. Again the first 15 imported fine, but the error again at row 16. Because the same data is simply attempted again in another CSV file, I do not think this is a problem with the data. I am doing my editing in Excel. Does Excel insert something into the file after import row 15?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just tried an import of 34 rows. The import threw the column count mismatch error starting at row 16. I trimmed the first 15 rows out and tried again. Again the first 15 imported fine, but the error again at row 16. Because the same data is simply attempted again in another CSV file, I do not think this is a problem with the data. I am doing my editing in Excel. Does Excel insert something into the file after import row 15?
Here is the answer: http://support.microsoft.com/kb/77295