How to store database records into array with VB.NET?

[dmoonme]

I want to retrieve all records from an MS Access table and store them into an array. Can someone give me an example of how to do that in VB.NET? Thanks in advance!

 

[Paszt]

Before answering, could you explain why you would want to do this? A little discussion may help you find a better solution. I would suggest using a dataset instead, but you may have a valid reason for using arrays.

 

[dmoonme]

The script is retrieving all directory names and sizes of a given network share.
I want to run the script so that it can look up multiple network shares. There's probably a better way to do this but I have the network share UNC paths in a database table. So that's why I want to retrieve the records in the table and store it into the array in order to pass the multiple network share paths to the script.