打开ADODB记录集并添加新记录的Python

pip install pyodbc

import pyodbc

conn_str = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path_to_your_database_file'
conn = pyodbc.connect(conn_str)

import pyodbc

conn_str = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path_to_your_database_file'
conn = pyodbc.connect(conn_str)

# 创建游标
cursor = conn.cursor()

# 执行查询操作
cursor.execute('SELECT * FROM your_table')

# 获取查询结果
rows = cursor.fetchall()

# 打印查询结果
for row in rows:
    print(row)

# 添加新记录
cursor.execute("INSERT INTO your_table (column1, column2) VALUES (?, ?)", ('value1', 'value2'))

# 提交事务
conn.commit()

# 关闭连接
conn.close()