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

# -*- coding: UTF-8 -*-

import pyodbc, os

database = os.getcwd()+'\\DB.accdb'
if os.path.exists(database):
    print 'DB exists!'
else:
    print 'Database not found!!!'
    exit()
    
constr = 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=%s;'  % database
conn = pyodbc.connect(constr)
cur = conn.cursor()

sql = "INSERT INTO clients_test (name,mailTo,mailCC,mailBCC,mailbox,description) VALUES (1,2,3,4,5,6)"
cur.execute(sql)

sql = "select * from clients_test"
cur.execute(sql)

result = cur.fetchall()
for item in result:
    print item

cur.close()
conn.close()

DB exists!
(51, u'1', u'2', u'3', u'4', u'5', u'6')