title: VBA Concatenate many variables into string
body: <p>I'm doing a relatively messy SQL string in VBA by concatenating many variables into SQL String and then executing the string in ADO.</p>
  
  <p>As an example here's some code:</p>
  
  <pre><code>Sql = "insert into mydb.dbo.table values ('" &amp; var1 &amp; "','" &amp; var2 &amp; "','" &amp; double1 &amp; "," &amp; double2 &amp; "," &amp; double3 &amp; ")"
  </code></pre>
  
  <p>I did not want to copy the entire code because frankly doing this for 27 variables might bore someone to death. Anyway the above code I repeat for 27 values in SQL (the SQL table obviously has 27 columns). However after 21 concatenations like this the string does not concatenate any further.</p>
  
  <p>The total string char length is 208 so surely it cannot be the VBA maximum of 252. Is there a maximum number of concated values to enter to a VBA string? Is there some other method I could use to achieve this goal?</p>
  
  <p>Many Thanks</p>