Export data from access

tripes

Member
Joined
Apr 16, 2009
Messages
18
Programming Experience
Beginner
hi i am using VB.NET 2003 and i want to export some data from a microsoft access database into a multidimensional array... how can i do that? i could not find a single example on this...pls help :(
 
I would suggest that that's a very bad idea. Multi-dimensional arrays have their place but the number of situations where their use is appropriate is very small. Data from a database is far better left in a DataTable or else in a 1-dimensional array or collection of objects that have a property for each column.

That said, if you really do want to use a 2D array then you should populate a DataTable first, then use nested For loops to visit every column of every row and transfer the data from the DataTable to the corresponding position in the array.
 
Back
Top