title: Change column data type and format
body: <p>When importing the excel to access 2007, some date field had become text field. so i want to run query in access to change those columns data type to datetime. How can i pass  the date format ("dd-mmm-yyyy") in sql ?</p>
  
  <pre><code>ALTER TABLE Tbl1 
  ALTER COLUMN [ABC] datetime
  </code></pre>
  
  <p>Thanks</p>
  
  <p>Joe</p>