title: Importing from Excel to SQL Server: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
body: <p>I have the following Excel Workbook:</p>
  <p><a href="https://meocloud.pt/link/7cb3ef48-7556-4d36-ab9a-c247d3f7b29d/FichasTeste.xls/" rel="nofollow noreferrer">https://meocloud.pt/link/7cb3ef48-7556-4d36-ab9a-c247d3f7b29d/FichasTeste.xls/</a></p>
  <p>It's formatted to be imported to a SQL Database. The server has the following details:</p>
  <p><img src="https://i.stack.imgur.com/XVHQN.png" alt="SQL Properties" /></p>
  <p>As you can see the mapping is correct in the importer
  <img src="https://i.stack.imgur.com/VNkZt.png" alt="Mapping" /></p>
  <p>When i try to import the excel file, the status is always the same, no matter the modifications i do to the columns with the Date.</p>
  <blockquote>
  <p>242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  <p>3621: The statement has been terminated.</p>
  </blockquote>
  <p>What should i modify so that those rows can be imported without having that error?</p>