学步园

python 操作Access数据库
首先下载 win32all at http://starship.python.net/crew/mhammond/win32/Downloads.html
然后安装，下面是一个例子;

import win32com.client
objConn = win32com.client.Dispatch(r'ADODB.Connection')
#connstr="Provider=SQLOLEDB; Data Source=el_servidor; Initial Catalog=base_de_datos; User Id=usuario; Password=contrase?a;"
connstr=r"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db2.mdb"
objConn.Open(connstr)
objRS = win32com.client.Dispatch(r'ADODB.Recordset')
SQLQuery="SELECT * from ipmac"
#一切如同ado一样
objRS.Open(SQLQuery, objConn,1,3)
while not objRS.EOF:
 print objRS("ip")
 objRS.MoveNext()
objRS.Close()
objRS = None
objConn.Close()
objConn = None

速度也不错