title: How to get all the data for the current date in ms Access using python?
body: <p>This is the picture of my data in access:</p>
  
  <p><img src="https://i.stack.imgur.com/UKzbT.png" alt="MS-ACESS table"></p>
  
  <p>And below is the code for getting all the data for the current month:</p>
  
  <pre><code>def access():
      l =[]
      conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\GOBOTIX\Desktop\dbSamp64.mdb;')
      cursor = conn.cursor()
      cursor.execute('select * from Table1 where Month(DateTime)=Month(Date())')
  
      for row in cursor.fetchall():
          l.append(row)
  </code></pre>
  
  <p>How can I obtain all the data for the current date?</p>