title: Fast Insert of raw binary data from multiple files to access database
body: <p>I'm looking for the fastest method to read from multiple binary files and write everything inside single MS Access database within multiple tables. SQL Server or any other database are not an option. I'm using C#.</p>
  
  <p>Let's say I have only one file containing 1 GB of data.</p>
  
  <ol>
  <li><p>File starts with header (containing column names code) followed by  more than 700 000 blocks of  measurement data. Header is less than 100 byte long. One data block is 1500 bytes long ( 372 x single float + 12 bytes for date and time)</p></li>
  <li><p>first 84 single values must be inserted in first database table</p></li>
  <li>remaining 288 single values are divided equally in 9 tables, 32 values each</li>
  <li>every table row has time and date as first column</li>
  </ol>
  
  <p>For now, I'm using binary reader. I'm reading block by block and executing INSERT statement (ADO.NET) 10 times per block. That would be more than 7 millions of INSERT.</p>
  
  <p>Execute time for 1.5MB is about 1 minute - 1GB would be more than 10 hours.</p>
  
  <p>Is there any way to do this much faster? What do you think is possible to expect?</p>