CData Python Connector for Access

Build 21.0.7930

Getting Started

Connecting to Access

Package Installation explains the available TAR.GZ files for the supported environments, as well as how to install the appropriate one to your python distribution.

Establishing a Connection indicates the module to import and shows how to configure the necessary connection properties in a connection string. Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Access can be installed and used in various Python 3.6, 3.7, 3.8, and 3.9 distributions (Mac is restricted to Python 3.8).

Access Version Support

The provider may work with Access 1997 (.mdb, r/o), Access 2000 (.mdb), Access 2003 (.mdb), Access 2007 (.accdb), Access 2010 (.accdb), Access 2013 (.accdb) database files.

See Also

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930