There a lot of times in my program where I have large arrays of data and I would like to use the power of SQL commands (SUM, GROUP BY, INNER JOIN, ORDER BY) on this information. It is a great tool when you are doing anything beyond the most basic information gathering.
For me to use this ability, everytime I have to take my arrays and dump them into an external Access db, create a recordset and do my work, then extract the information and kill the database. I was wondering if there is another way to harness all the abilities of SQL commands and database tools, without having to actually create an external database each time? I don't know, like maybe just using the basic database engine on an array?? Sometimes it seems like a convoluted process....