Does anyone have any comma sense out there?

[JimMuglia]

Greetings,

Attached is a zip file containing a csv file. I am writing a program that needs to parse the file for importing its items to a database.

In toggling through the code I am using, for line input, instead of givng the whole line it sometimes gives the last word or number of a line, preceeded by a bunch of commas.

Here is what I am asking:
In parsing a .csv file, in the context of the "while not eof() loop", how can I input each "line", soas to make sure I see all the information and can parse it?

Right now, the "tmp" values are missing some stuff that, I think should be appearing? In other words, I am not capturing all the data on a line with the Line Input command.

Do While Not EOF(1)
Line Input #1, tmp
Loop

Can someone give me some direction on this (i.e. the best way to parse a .csv file, like the one attached)?

Thank you,
Jim