使用Python对Access读写操作方法详解

import win32com.client

conn = win32com.client.Dispatch(r"ADODB.Connection")
DSN = 'PROVIDER = Microsoft.Jet.OLEDB.4.0;DATA 
SOURCE = test.mdb'conn.Open(DSN)

rs = win32com.client.Dispatch(r'ADODB.Recordset')
rs_name = 'MEETING_PAPER_INFO'rs.Open('[' + 
rs_name + ']', conn, 1, 3)

rs.AddNew() #添加一条新记录
rs.Fields.Item(0).Value = "data" #新记录的第一个字段设为
"data"rs.Update() #更新

# 增
sql = "Insert Into [rs_name] (id, innerserial, mid) Values ('0021338000880002', 2, '21338')" #sql语句
conn.Execute(sql) #执行sql语句
# 删
sql = "Delete * FROM " + rs_name + " where innerserial = 2"
conn.Execute(sql)
# 改
sql = "Update " + rs_name + " Set mid = 2016 where innerserial = 3"
conn.Execute(sql)

rs.MoveFirst() #光标移到首条记录
count = 0
while True:
 if rs.EOF:
 break
 else:
 for i in range(rs.Fields.Count):
 #字段名：字段内容
 print(rs.Fields[i].Name, "：", rs.Fields[i].Value)
 count += 1
 rs.MoveNext()

conn.close()