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
Objectives
This dialect is mainly intended to offer pandas users an easy way to save a DataFrame into an Access database via to_sql.
Pre-requisites
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.
Co-requisites
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
Getting Started
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.
The SQLAlchemy Project
SQLAlchemy-access is part of the SQLAlchemy Project and adheres to the same standards and conventions as the core project.
Development / Bug reporting / Pull requests
Please refer to the SQLAlchemy Community Guide 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.
License
SQLAlchemy-access is distributed under the MIT license.
3 maintainers
Metadata
3 maintainers
Release files for sqlalchemy-access 2.0.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlalchemy_access-2.0.3.tar.gz | 18.0 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlalchemy_access-2.0.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 32.0 kB
Release files / sqlalchemy_access-2.0.3.tar.gz
| Download URL | sqlalchemy_access-2.0.3.tar.gz |
|---|---|
| Size | 18.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
89174a94e0ebd6c32470282d143aef0c0fbe3aafdee2c40956cd417648cb317e
|
|
BLAKE2b-256 checksum How to use checksums |
3fe302801e7b150342be8b7146227beb7943723511eb2f074bb836eae05e7578
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.1 CPython/3.11.4
|
Release files / sqlalchemy_access-2.0.3-py3-none-any.whl
| Download URL | sqlalchemy_access-2.0.3-py3-none-any.whl |
|---|---|
| Size | 14.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
e50dba5cbf346ad1599ee87ff83260f70c39b555b0277bc63321fefa7f022e48
|
|
BLAKE2b-256 checksum How to use checksums |
957a3b1e307688795342f977d54b6f9d56665860455663859bd459ee117f7179
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.1 CPython/3.11.4
|
