title: Insert  many records using ADO
body: <p>I am looking the fastest way to insert many records at once (+1000) to an table using <strong>ADO</strong>.</p>
  
  <p>Options:</p>
  
  <ol>
  <li><p>using insert commands and parameters</p>
  
  <pre><code>ADODataSet1.CommandText:='INSERT INTO .....';    
  ADODataSet1.Parameters.CreateParameter('myparam',ftString,pdInput,12,''); 
  ADODataSet1.Open;
  </code></pre></li>
  <li><p>using <code>TAdoTable</code></p>
  
  <pre><code>AdoTable1.Insert;
  AdoTable1.FieldByName('myfield').Value:=myvale;
  //..
  //..
  //..
  AdoTable1.FieldByName('myfieldN').value:=myvalueN;
  AdoTable1.Post;
  </code></pre></li>
  <li><p>I am using delphi 7, ADO, and ORACLE.</p></li>
  </ol>