title: Adding VBA Array to New Access DB
body: <p>I'm pretty proficient with VBA, but I know almost nothing about Access! I'm running a complex simulation using Arrrays in VBA, and I want to store the results somewhere. Since the results of the simulation will be quite large (~1GB in memory), I'd like to store this in Access rather than Excel.</p>
  
  <p>I currently have a large number of Arrays populated with my data, but I'm not sure how to write these to a database, or even how to create one with VBA. Here's what I need to do, in a nutshell, with VBA:</p>
  
  <ul>
  <li>Create a new Access Database</li>
  <li>Create a new Access Table (the db will be only a single table)</li>
  <li>Create ~1200 fields programmatically</li>
  <li>Copy the results from my arrays to the new Access table.</li>
  </ul>
  
  <p>I've looked at a number of answers on here, but none of them seem to answer my question fully. For instance, <a href="https://stackoverflow.com/questions/24368926/adding-field-to-ms-access-table-using-vba">Adding field to MS Access Table using VBA</a> talks about adding fields to a database. But I don't see doubles listed here. Most of my arrays are doubles. Will this be a problem?</p>
  
  <p>EDIT:</p>
  
  <p>Here are a few more details about the project:</p>
  
  <p>I am running a network design simulation. Thus, I start by generating ~150,000 unique networks. Then, I run a lot of calculations (no, these can't be simplified to queries unfortunately!) of characteristics for the network. There end up being ~1200 for each possible network (unique record). Thus, I would like to store these in an Access database. Each record will be a unique network, and each field will be a specific characteristic associated with that network.</p>
  
  <p>Virtually all of the fields (arrays at this point!) are doubles. </p>