.. image:: https://img.shields.io/pypi/dm/sqlalchemy-access.svg :target: https://pypi.org/project/sqlalchemy-access/
A Microsoft Access dialect for SQLAlchemy on Windows.
The latest version of this dialect requires SQLAlchemy 2.0 or later. To work with earlier versions of SQLAlchemy, do::
pip install sqlalchemy-access<2.0.0
This dialect is mainly intended to offer
pandas users an easy way to save a DataFrame into an
Access database via to_sql.
If you already have Microsoft Office (or standalone Microsoft Access) installed then install a version of Python with the same "bitness". For example, if you have 32-bit Office then you should install 32-bit Python.
If you do not already have Microsoft Office (or standalone Microsoft Access) installed then install the version of the Microsoft Access Database Engine Redistributable with the same "bitness" as the version of Python you will be using. For example, if you will be running 64-bit Python then you should install the 64-bit version of the Access Database Engine.
Special case: If you will be running 32-bit Python and you will only be working with .mdb files
then you can use the older 32-bit Microsoft Access Driver (*.mdb) that ships with Windows.
This dialect requires SQLAlchemy, pyodbc, and pywin32. They are specified as requirements so pip
will install them if they are not already in place. To install, just::
pip install sqlalchemy-access
Create an ODBC DSN (Data Source Name)_ that points to your Access database.
(Tip: For best results, enable ExtendedAnsiSQL_.)
Then, in your Python app, you can connect to the database via::
from sqlalchemy import create_engine
engine = create_engine("access+pyodbc://@your_dsn")
For other ways of connecting see the Getting Connected_ page in the Wiki.
.. _ODBC DSN (Data Source Name): https://support.microsoft.com/en-ca/help/966849/what-is-a-dsn-data-source-name .. _ExtendedAnsiSQL: https://github.com/sqlalchemy/sqlalchemy-access/wiki/%5Btip%5D-use-ExtendedAnsiSQL .. _Getting Connected: https://github.com/sqlalchemy/sqlalchemy-access/wiki/Getting-Connected
SQLAlchemy-access is part of the SQLAlchemy Project <https://www.sqlalchemy.org>_ and
adheres to the same standards and conventions as the core project.
Please refer to the
SQLAlchemy Community Guide <https://www.sqlalchemy.org/develop.html>_ for
guidelines on coding and participating in this project.
Code of Conduct
Above all, SQLAlchemy places great emphasis on polite, thoughtful, and
constructive communication between users and developers.
Please see our current Code of Conduct at
Code of Conduct <https://www.sqlalchemy.org/codeofconduct.html>_.
SQLAlchemy-access is distributed under the MIT license <https://opensource.org/licenses/MIT>_.
FAQs
MS Access for SQLAlchemy
We found that sqlalchemy-access demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 3 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
PyPI confirms no security flaws were exploited in the Ultralytics supply chain attack and highlights improvements for safer package publishing.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.