title: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
body: <p>i am working on importing data from excel to sql server. i am facing problem while i am inserting the date and datetime values in sql server. It is showing me this error:</p>
  
  <pre><code>[System.Data.SqlClient.SqlException] = {"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.\r\nThe statement has been terminated."}
  </code></pre>
  
  <p>the date and date time format in excel sheet are in this format:</p>
  
  <pre><code>  Date          DateTime
  2011-04-26  2011-04-26 13:30
  </code></pre>
  
  <p>What do i have to to do to import these two values to database?</p>