Python-сообщество

 # http://mail.python.org/pipermail/python-win32/2011-January/011086.html
import adodbapi # http://adodbapi.sourceforge.net/
database = "db1.accdb"
constr = 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=%s'  % database
tablename = "address"
print(database)
# connect to the database
conn = adodbapi.connect(constr)
# create a cursor
cur = conn.cursor()
# extract all the data
sql = "select * from %s" % tablename
cur.execute(sql)
print(database)
# show the result
result = cur.fetchall()
for item in result:
    print (item)
    
# close the cursor and connection
cur.close()
conn.close()

 C:\Users\Anton\AppData\Local\Programs\Python\Python36-32\python.exe C:/Users/Anton/PycharmProjects/BASES/Access.py
db1.accdb
Traceback (most recent call last):
  File "C:\Users\Anton\AppData\Local\Programs\Python\Python36-32\lib\site-packages\adodbapi\adodbapi.py", line 93, in make_COM_connecter
    c = Dispatch('ADODB.Connection') #connect _after_ CoIninialize v2.1.1 adamvan
NameError: name 'Dispatch' is not defined
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "C:\Users\Anton\AppData\Local\Programs\Python\Python36-32\lib\site-packages\adodbapi\adodbapi.py", line 112, in connect
    co.connect(kwargs)
  File "C:\Users\Anton\AppData\Local\Programs\Python\Python36-32\lib\site-packages\adodbapi\adodbapi.py", line 269, in connect
    self.connector = connection_maker()
  File "C:\Users\Anton\AppData\Local\Programs\Python\Python36-32\lib\site-packages\adodbapi\adodbapi.py", line 95, in make_COM_connecter
    raise api.InterfaceError ("Windows COM Error: Dispatch('ADODB.Connection') failed.")
adodbapi.apibase.InterfaceError: Windows COM Error: Dispatch('ADODB.Connection') failed.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "C:/Users/Anton/PycharmProjects/BASES/Access.py", line 13, in <module>
    conn = adodbapi.connect(constr)
  File "C:\Users\Anton\AppData\Local\Programs\Python\Python36-32\lib\site-packages\adodbapi\adodbapi.py", line 116, in connect
    raise api.OperationalError(e, message)
adodbapi.apibase.OperationalError: (InterfaceError("Windows COM Error: Dispatch('ADODB.Connection') failed.",), 'Error opening connection to "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db1.accdb"')
Process finished with exit code 1