I want to append a text file which is delimted by commas. I have a problem with consecutive commas. I want the extra commas to be acknowledged as a place holder. How do I go about doing this?

Example: John,,Smith
if I had a table with first,MI,Lastname. I want the last name to go into the proper field. As is, it would be placed in the MI field automatically, because the double commas are being ignored.

TIA,

Jim