Create an Access Table from an ArrayList in VBA

Question

I have an ArrayList for which I need to use the records in an Access Query.  Is there a way to create an Access Table from the ArrayList, or pass the data directly into the criteria of my data?

Answer 1

ArrayList is not part of VBA, so I assume you made a reference to the .NET System.Collections namespace, or you're using GetObject?

If so, and if all you're doing is storing data then you'd be MUCH better off using a standard VBA Array. While you can work with some of the .NET stuff in VBA, it's well known to cause issues (out of memory, for one), since all too often those .NET objects work with values that VBA and Access simply don't understand, and will try to convert.

Answer 2

Thank you Daniel, let me see what I can do.

Answer 3

Thanks Tom, but I did create my ArrayList in VBA.

Answer 4

"ArrayList" seems to indicate you are in a .NET application. You want to populate your ArrayList with the results of an Access query. There are MANY ways to use databases in .NET applications. It's out of scope of this forum to get into that. You best ask in a forum about .NET database programming.

Answer 5

You could iterate through the array an execute a series of insert queries to populate your table.