title: How to read Ms access DB table in python with file extension .accdb?
body: <p>I am trying to read a table from access DB and use it as dataframe of pandas.
  I am trying to read it from cloud. This database is not present in my local system.
  Although i tried copying the table to local system and in same directory in which program is written but still getting same error.
  I have used this code:</p>
  <pre><code>conn=pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};'
  r'DBQ=APR.accdb;'
  r'Provider=MSDASQL')
  #conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\somya_chaturvedi1\Box\Pre APR Automation\eWB - FrontEnd v6.3.3 - CRISIL.accdb;')
  cursor = conn.cursor()
  cursor.execute('select * ABS/RMBS APRs')
     
  for row in cursor.fetchall():
      print (row)
  </code></pre>
  <p>I am getting following error for this one:</p>
  <blockquote>
  <p>InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager]
  Data source name not found and no default driver specified (0)
  (SQLDriverConnect)')</p>
  </blockquote>
  <p>I tried to check version of both python and Ms access to both be 32 bit.
  i am not able to configure and what should be done.
  Please Help
  Thank you</p>