title: Bulk insert into SQL Server with vba
body: <p>I am trying to insert a lot of values into SQL Server in one SQL insert statement. using a call of Proc Stock with my VBA code 
  for example :</p>
  
  <pre><code>[... definitions of variables ...]
       If Not dico Is Nothing Then
          For Each current_id In dico.Keys
              Set prm = .CreateParameter(CStr(current_id), adVarChar, adParamInput, str_length, current_value)
              .Parameters.Append prm
          Next current_id
  </code></pre>
  
  <p>this code works perfectly when i have a single dictionary
  but how about when i have an array of dictionaries , can prm contains a list of values (all values in a dico) instead of one value (.Parameters become a list of lists)? there is other methode to do that?</p>
  
  <p>Thank you ,</p>