Connecting to Microsoft Access

For information on the available WHL and TAR.GZ files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Microsoft Access can be installed and used in various Python 3.8, 3.9, 3.10, and 3.11 distributions.

Microsoft Access Version Support

The connector connects to Microsoft Access Database files stored locally on disk. Supported filetypes include Microsoft Access 1997 (.mdb, r/o), Access 2000 (.mdb), Access 2003 (.mdb), Access 2007 (.accdb), Access 2010 (.accdb), Access 2013 (.accdb), Access 2016 (.accdb) and Access 2019 (.accdb) database files.

See Also

• Using the Connector: Establish connections and query Microsoft Access through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with Microsoft Access data using mapped classes and Sessions.