pyodbc操作Access2013

# 测试环境：32位python access database engine 32位
# pyodbc文档 https://github.com/mkleehammer/pyodbc/wiki
 
import pyodbc

# 驱动程序
for x in [x for x in pyodbc.drivers()]:
    if 'Access' in x and 'accdb' in x:
        print(x)

# 连接Access2013数据库
path = r'C:\Users\Administrator\Desktop\test.accdb'
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=' + path + ';Uid=;Pwd=' )

# 获取游标
cursor = conn.cursor()

# 表结构
for table in cursor.tables(tableType='TABLE'):
    print(table.table_name)
for column in cursor.columns(table='表1'):
    print(column)

# dml     
cursor.execute("insert into 表1 (rq) values ('2020-12-2')")
cursor.commit()


# dql
l = cursor.execute('select * from 表1')
for item in l:
    print(item)

cursor.close()
conn.close()