title: How to insert a data table into SQL Server database table?
body: <p>I have imported data from some Excel file and I have saved it into a <code>datatable</code>. Now I'd like to save this information in my <code>SQL Server</code> database.</p>
  
  <p>I saw a lot of information on the web but I cannot understand it:</p>
  
  <ol>
  <li>Someone said insert line by line another suggested bulk update... etc: what it better?</li>
  <li>Should I use <code>OLE</code> or <code>SQL Server</code> objects (like <code>dataAdapter</code> or <code>connection</code>)?</li>
  </ol>
  
  <p>My need is to read the employee weekly hours report, from his Excel file and save it to a database table where all the reports are saved (updating the db with new records every week).</p>
  
  <p>The Excel file contains reports only for the current week.</p>