Using .eof to control a loop is a Bad Idea, inasmuch as it doesn't actually work.
Given a generic CSV file, all you do is look for commas (and new lines, of course). If you're allowed something like 1234,"Lastname, Firstname", 1 with a comma inside quotes that doesn't count then you'll have to be a little more careful.