import adodbapi # http://adodbapi.sourceforge.net/
database = "A.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()