Populate table from array

Can anyone give me an example of how to create a standalone DBF table from array elements using VBA?

I would like to be able to loop through a sorted array, split the array into multiple arrays of equal size and write these as separate columns with field names added into a DBF table.

Or a better way to accomplish same.

Thanks

Where does the array originate from? Excel, Access?..

Where does the array originate from? Excel, Access?..

The array was created from a textfile, then some additional items were added and the array sorted. The application is ESRI's ArcGIS 8.3, an app that uses VBA. If I can work it out on the VBA side, the app side should be easy.


Input looks like this:

"1075 East Rd ","13-D "
"10th St ","11-H "
"11th St ","12-H "
"1200 East Rd ","5-E "
"1200 North Rd ","11-M "
"12th St ","12-H "