title: Excel VBA insert array variable into single field in access
body: <p>In my project I'm trying to save indefinite entry in excel sheet into the database (access). I'm trying to use vba to do so. However, because I don't know how long the entries will be, and I can't create so many fields in the database to fit the unknown amount of entries. And I can't INSERT an array variable into one field in the table. How can I do this?</p>
  
  <p>Say I have below.</p>
  
  <pre><code>Dim SN(100) As String
  SN(0)=123    'value of each entry
  SN(1)=2412
  'so on and so many entries
  </code></pre>
  
  <p>Then in the SQL statement,</p>
  
  <pre><code>"INSERT INTO [TableName] ([FieldName]) Values (SN)"
  </code></pre>
  
  <p>It will say RunTime Error "13" Type mismatch.</p>
  
  <p>Is there any way the database field can accept a list or array as data type? So when I call the data out I can use the index to call the variable inside the list?</p>