title: Convert Excel Date to Sql Server Date Time format using ACE Provider VB.Net
body: <p>I am attempting to import data in a batch from an Excel Worksheet to a Sql Server database.  Everything works except for the one date field in the spreadsheet.  The date returned is off by four years from the value in the spreadsheet.<br>
  Example: The Excel sheet has a date <code>10/24/2010 14:18</code>, but when I look at the column in my query, the date is <code>10/23/2006 2:18</code>.  This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.  </p>
  
  <p>The Excel column comes to me as a custom type, formatted <code>m/d/yyyy h:mm</code>.  I receive this from an outside vendor and having them change the column is not going to be my simplest solution.  I'm hoping that someone has worked with this and can point me in the right direction.  </p>
  
  <p>For what it's worth, the relevent part of the query is: </p>
  
  <blockquote>
    <p>Select [Date Created] From MyWorksheet</p>
  </blockquote>
  
  <p>TIA.</p>