-
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
