Populate Array with SQL query string
I need to dynamically build a multi-dimensional array with a set of records from a query string. I have the code to pull the data into a dataset but cannot quite figure out how to populate an array.
strSql = "select fname, lname, phone from employee"
OpenDataSet(dsData2, strSql, "tblReportInfo", strDB)
How do I fill an array with that dataset?