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 ('002133800088980002', 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 = 0while 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()

#!/usr/bin/env python# -*- coding:utf-8 -*-__author__ = "loki"import timeimport pypyodbc as mdb# 連接mdb文件connStr = (r'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/MDB_demo/demo.mdb;'   r'Database=bill;'   )conn = mdb.win_connect_mdb(connStr)# connStr = (#  r'Driver={SQL Sever};'#  r'Server=sqlserver;'#  r'Database=bill;'#  r'UID=sa;'#  r'PWD=passwd'# )## conn = mdb.connect(connStr)# 創建游標cur = conn.cursor()cur.execute('SELECT * FROM bill;')for col in cur.description: # 展示行描述 print(col[0], col[1])result = cur.fetchall()for row in result: # 展示個字段的值 print(row) print(row[1], row[2]

# Microsoft Access DBimport pypyodbc connection = pypyodbc.win_create_mdb('D://database.mdb')SQL = 'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25));'connection.cursor().execute(SQL)connection.close()

#SQL Server 2000/2005/2008 (and probably 2012 and 2014)import pypyodbc as pyodbc # you could alias it to existing pyodbc code (not every code is compatible)db_host = 'serverhost'db_name = 'database'db_user = 'username'db_password = 'password'connection_string = 'Driver={SQL Server};Server=' + db_host + ';Database=' + db_name + ';UID=' + db_user + ';PWD=' + db_password + ';'db = pyodbc.connect(connection_string)SQL = 'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25));'db.cursor().execute(SQL)# Doing a simple SELECT queryconnStr = ( r'Driver={SQL Server};' r'Server=sqlserver;' #r'Server=127.0.0.1,52865;' + #r'Server=(local)/SQLEXPRESS;' r'Database=adventureworks;' #r'Trusted_Connection=Yes;' r'UID=sa;' r'PWD=sapassword;' )db = pypyodbc.connect(connStr)cursor = db.cursor()# Sample with just a raw query:cursor.execute("select client_name, client_lastname, [phone number] from Clients where client_id like '01-01-00%'")# Using parameters (IMPORTANT: YOU SHOULD USE TUPLE TO PASS PARAMETERS)# Python note: a tuple with just one element must have a trailing comma, otherwise is just a enclosed variablecursor.execute("select client_name, client_lastname, [phone number] ""from Clients where client_id like ?", ('01-01-00%', ))# Sample, passing more than one parametercursor.execute("select client_name, client_lastname, [phone number] ""from Clients where client_id like ? and client_age < ?", ('01-01-00%', 28))# Method 1, simple reading using cursorwhile True: row = cursor.fetchone() if not row:  break print("Client Full Name (phone number): ", row['client_name'] + ' ' + row['client_lastname'] + '(' + row['phone number'] + ')')# Method 2, we obtain dict's all records are loaded at the same time in memory (easy and verbose, but just use it with a few records or your app will consume a lot of memory), was tested in a modern computer with about 1000 - 3000 records just fine...import pprint; pp = pprint.PrettyPrinter(indent=4)columns = [column[0] for column in cursor.description]for row in cursor.fetchall(): pp.pprint(dict(zip(columns, row)))# Method 3, we obtain a list of dict's (represents the entire query)query_results = [dict(zip([column[0] for column in cursor.description], row)) for row in cursor.fetchall()]pp.pprint(query_results)# When cursor was used must be closed, if you will not use again the db connection must be closed too.cursor.close()db.close()