pyaccesskit

PyAccessKit: a modern, typed, Pythonic toolkit for Microsoft Access databases and applications.

Quick start::

from pyaccesskit import AccessDatabase, Column

with AccessDatabase.create("crm.accdb") as db:
    db.tables.create(
        "Customers",
        columns=[
            Column.autonumber("CustomerID", primary_key=True),
            Column.text("CustomerName", length=200, required=True),
        ],
    )

Everything listed in pyaccesskit.__all__ is importable from the top-level package; the pages in this section document each object in the module that defines it.