Using Visual Basic 6, I'm trying to import a non comma separated text file to a database and I'm inputting("Input #1") the lines line by line and then I test it with a series of If statements using "mid(integer, 1, 10)" (this is an example). Now this is all fine but if one of those (1+10)characters is a comma (like "Long, Mike") then it goes to the next field and throws the hole thing off.
Can someone help me?


/\
/ \
____/ \ __/\ ___________________
\ / \/
\ /
\/