title: Update database (mdb) problem using python: Datatype is datetime but require float when using UPDATE
body: <p><a href="https://i.stack.imgur.com/SFxBz.png" rel="nofollow noreferrer">my table</a></p>
  <p>I got a problem when I try to use UPDATE to update my database. My table has 6 columns (datatype are str, datetime, int, int, float, and int, respectively). I write a python command as follow:</p>
  <p>cur.execute(&quot;UPDATE DISCHARGE1 SET DataValue=200, flag=1 WHERE Station='12345' and DataDate='12/16/2021' and DataHour=1 and DataMinute=0&quot;)</p>
  <p>then I got error:
  cur.execute(&quot;UPDATE DISCHARGE1 SET DataValue=200, flag=1 WHERE Station='12345' and DataDate='12/16/2021' and DataHour=1 and DataMinute=0&quot;)
  pyodbc.DataError: ('22018', '[22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. (-3030) (SQLExecDirectW)')</p>
  <p>I checked and realized the problem is in the datatype of DataDate column. I then remove ' ' and the code run without error but nothing is updated. Despite the datatype of the DataDate column is datetime, the datatype required in &quot;UPDATE&quot; line is float. Somebody help me</p>