title: Oracle insert failure : not a valid month
body: <p>I'm trying to import data from an .xlsx spreadsheet which contains date columns. In those columns, dates are displayed in the DD-MON-YY format (for example : 20-AUG-12).</p>
  
  <p>When I'm running the import wizard, everything goes fine until I must precise the columns/fields mapping. I've got a disclaimer saying that the chosen format is not matching the table field definition (my field is a date field). An example of the insert script : </p>
  
  <pre><code>INSERT INTO simulation 
              (simulation_id, 
               simulation_name, 
               sim_start_date, 
               sim_end_date, 
               status, 
               last_run_date, 
               moddat, 
               modusr, 
               notification_email) 
  VALUES      (251.0, 
               'Proposal Test', 
               To_date('01-DEC-11', 'DD-MON-YY'), 
               To_date('31-DEC-11', 'DD-MON-YY'), 
               'C', 
               To_date('09-AUG-12', 'DD-MON-YY'), 
               To_date('09-AUG-12', 'DD-MON-YY'), 
               'Brent Weintz', 
               'bweintz@carlsonwagonlit.com'); 
  </code></pre>
  
  <p>When I'm trying to run this query, I got the following error : </p>
  
  <blockquote>
    <p>ORA-01843: not a valid month
    01843. 00000 -  "not a valid month"</p>
  </blockquote>
  
  <p>As you can see, the formats are matching and I can't figure out where the problem is... Any idea guys?</p>
  
  <p>EDIT : My date language paramater is set to "FRENCH". Can I change it to "AMERICAN" ?</p>