title: How to populate an array with recordset data
body: <p>I am attempting to move data from a recordset directly into an array. I know this is possible, but specifically I want to do this in VBA as this is being done in MS Access 2003.</p>
  
  <p>Typically I would do something like the following to achieve this:</p>
  
  <pre><code>    Dim vaData As Variant 
      Dim rst As ADODB.Recordset
  
      ' Pull data into recordset code here...
  
      ' Populate the array with the whole recordset.
      vaData = rst.GetRows 
  </code></pre>
  
  <p>What differences exist between VB and VBA which makes this type of operation not work?</p>
  
  <p>What about performance concerns? Is this an "expensive" operations?</p>