Using the Connector
This section provides a walk-through for writing Access data access code in Python script.
See Data Model for more information on the available data source entities and how to query them with SQL.
Connecting from Code
To connect with the access.connector module and its related classes, see Connecting.
The connection's cursor object is used to directly execute SQL queries. See Querying Data to execute SELECT statements and process the returned result sets. See Updating Data to modify the data in Access with INSERT, UPDATE, and DELETE statements.
Executing Stored Procedures
You can call stored procedures by using the EXECUTE statement. See Calling Stored Procedures for more information.
See Batch Processing to modify several rows of Access data at once using parameterized INSERT, UPDATE, and DELETE statements.