PyADO

This allows a connection to any OLE DB driver/database using standard DB-API code.

PyADO is written entirely in Python, and uses the Python for Windows extensions to interface with COM.

Although it is also possible to use ADO directly from Python, with the Windows extensions,
this driver allows code written to use DB-API 2.0 to use ADO, which means that
this code will be portable to other Python database drivers.

The source code is licensed under the Python license (Python Software Foundation version).

This example connects to an Access database in C:\test.mdb. Note that host should be
set to None unless you are using SQL Server... Also note that you need to pass the OLE DB provider
name as a parameter to connect

Now you need a cursor to execute statements on:

curs = conn.cursor()

Now let's run a SQL statement (you will need to put a useful statement here):