title: How to properly save Date into Microsoft Access?
body: <p>I am trying to populate my Access Table that has a date column from my excel, so in my excel I have <code>DateOfBirth</code> formatted as <code>dd/mm/yyyy</code>. In my Visual Basic Code this line print my date properly:
  <code>MsgBox &quot;DOB: &quot; &amp; Format(xlWs.Cells(i, 9), &quot;dd/mm/yyyy&quot;)</code>. My problem now is using this code:</p>
  <pre><code>sql = &quot;INSERT INTO Persons(PersonName, Dob) VALUES('&quot; &amp; xlWs.Cells(i, 8) &amp; &quot;',&quot; &amp; Format(xlWs.Cells(i, 9), &quot;dd/mm/yyyy&quot;) &amp; &quot;);&quot;
  DoCmd.SetWarnings False
  DoCmd.RunSQL (sql)
  DoCmd.SetWarnings True
  </code></pre>
  <p>where <code>xlWs.Cells(i, 9)</code> is the date from my excel column and dob column in my table is of type <strong>Date/Time</strong> and Format as <strong>Short Date</strong>. My problem now is all my rows in dob column in  <strong>Persons</strong> table becomes: <strong>30/12/1899</strong>. How to fix this?</p>