Is there a header row that you are counting that does not contain actual data?

Look at your target table and try to determine if it is the first or last row that is missing, or some row in between. First or last row missing is usually indicative of a problem with the record delimiter in the source file that you will have to code around. If all the data for the missing row crammed into the last column (or other column) on another row you will frequently find a column delimiter in the data. For example if your text file is comma delimited and there is a column with a number that has a thousands separator like 1,589.