I have a comma delimited file in this format
value1, value2, value3, value4
value1, value2, value3, value4
value1, value2, value3, value4

How can I open the file and read the data into fields? i.e,
lastName, firstName, phoneNo, Age

I've found many sample but they all cover reading the textfile,
I need to know how to read the text file but split the line or
read each value into a field.

Any help would be deeply appreciated. Thanks.

hi there..

if you already found out how to read the file, read every line and then use the split function to get every value...

HTH

Gonzalo

In addition to using split, you can use a loop. Use InStr() to find the location of the first comma.
Put all upt to that point-1 into the first field [fld = Left$(strStuff, CmaLoc -1)].
Find the next comma.
Read all into the next field from the previous comma's location + 1 to the current comma's location - 1.
Keep doing this till you run out of commas, finally using all of the end of the string following the last comma.