If you save your file before importing to Access, it should then show the correct number of lines. Test using End-Home.