Using the Split() Function

[overhill]

I have a tab delimited database that I need to load into an array. Each record ends with a vbCrlf. Each record is then made up of 7 fields separated by tabs.

I have used the Split function to create an array of all of the records. Now I need to subdivide each of these records into the seven individual fields. How can I do this?

If it is possible, I would like to have the database in a custom type similar to this.

Record(x).Field1
Record(x).Field2
Record(x).Field3
Record(x).Field4
Record(x).Field5
Record(x).Field6
Record(x).Field7

Thanks for any help!

You could use Split() again on your tab delimitted record:

varFields = Split(strRecord, vbTab)


Paul