sqlalchemy-access
=================
.. image:: https://img.shields.io/pypi/dm/sqlalchemy-access.svg
:target: https://pypi.org/project/sqlalchemy-access/
A Microsoft Access dialect for SQLAlchemy.
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.
.. _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
The SQLAlchemy Project
======================
SQLAlchemy-access is part of the `SQLAlchemy Project <https://www.sqlalchemy.org>`_ and
adheres to the same standards and conventions as the core project.
Development / Bug reporting / Pull requests
-------------------------------------------
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>`_.
License
=======
SQLAlchemy-access is distributed under the `MIT license
<https://opensource.org/licenses/MIT>`_.
Raw data
{
"_id": null,
"home_page": "https://github.com/gordthompson/sqlalchemy-access",
"name": "sqlalchemy-access",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "SQLAlchemy Microsoft Access",
"author": "Gord Thompson",
"author_email": "gord@gordthompson.com",
"download_url": "https://files.pythonhosted.org/packages/53/3f/5766d698b5e61a083905a903fcae6c2045e4262b0f2cbe59193c5da7ea80/sqlalchemy-access-2.0.2.tar.gz",
"platform": null,
"description": "sqlalchemy-access\r\n=================\r\n\r\n.. image:: https://img.shields.io/pypi/dm/sqlalchemy-access.svg\r\n :target: https://pypi.org/project/sqlalchemy-access/\r\n\r\nA Microsoft Access dialect for SQLAlchemy.\r\n\r\nThe latest version of this dialect requires SQLAlchemy 2.0 or later.\r\nTo work with earlier versions of SQLAlchemy, do::\r\n\r\n pip install sqlalchemy-access<2.0.0\r\n\r\nObjectives\r\n----------\r\n\r\nThis dialect is mainly intended to offer\r\npandas users an easy way to save a DataFrame into an\r\nAccess database via ``to_sql``.\r\n\r\nPre-requisites\r\n--------------\r\n\r\n- If you already have Microsoft Office (or standalone Microsoft Access) installed then install a version\r\n of Python with the same \"bitness\". For example, if you have 32-bit Office then you should install\r\n 32-bit Python.\r\n\r\n- If you do not already have Microsoft Office (or standalone Microsoft Access) installed then install\r\n the version of the Microsoft Access Database Engine Redistributable with the same \"bitness\" as the\r\n version of Python you will be using. For example, if you will be running 64-bit Python then you\r\n should install the 64-bit version of the Access Database Engine.\r\n\r\nSpecial case: If you will be running 32-bit Python and you will **only** be working with .mdb files\r\nthen you can use the older 32-bit ``Microsoft Access Driver (*.mdb)`` that ships with Windows.\r\n\r\nCo-requisites\r\n-------------\r\n\r\nThis dialect requires SQLAlchemy, pyodbc, and pywin32. They are specified as requirements so ``pip``\r\nwill install them if they are not already in place. To install, just::\r\n\r\n pip install sqlalchemy-access\r\n\r\nGetting Started\r\n---------------\r\n\r\nCreate an `ODBC DSN (Data Source Name)`_ that points to your Access database.\r\n(Tip: For best results, enable `ExtendedAnsiSQL`_.)\r\nThen, in your Python app, you can connect to the database via::\r\n\r\n from sqlalchemy import create_engine\r\n engine = create_engine(\"access+pyodbc://@your_dsn\")\r\n\r\nFor other ways of connecting see the `Getting Connected`_ page in the Wiki.\r\n\r\n.. _ODBC DSN (Data Source Name): https://support.microsoft.com/en-ca/help/966849/what-is-a-dsn-data-source-name\r\n.. _ExtendedAnsiSQL: https://github.com/sqlalchemy/sqlalchemy-access/wiki/%5Btip%5D-use-ExtendedAnsiSQL\r\n.. _Getting Connected: https://github.com/sqlalchemy/sqlalchemy-access/wiki/Getting-Connected\r\n\r\nThe SQLAlchemy Project\r\n======================\r\n\r\nSQLAlchemy-access is part of the `SQLAlchemy Project <https://www.sqlalchemy.org>`_ and\r\nadheres to the same standards and conventions as the core project.\r\n\r\nDevelopment / Bug reporting / Pull requests\r\n-------------------------------------------\r\n\r\nPlease refer to the\r\n`SQLAlchemy Community Guide <https://www.sqlalchemy.org/develop.html>`_ for\r\nguidelines on coding and participating in this project.\r\n\r\nCode of Conduct\r\n_______________\r\n\r\nAbove all, SQLAlchemy places great emphasis on polite, thoughtful, and\r\nconstructive communication between users and developers.\r\nPlease see our current Code of Conduct at\r\n`Code of Conduct <https://www.sqlalchemy.org/codeofconduct.html>`_.\r\n\r\nLicense\r\n=======\r\n\r\nSQLAlchemy-access is distributed under the `MIT license\r\n<https://opensource.org/licenses/MIT>`_.\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "MS Access for SQLAlchemy",
"version": "2.0.2",
"project_urls": {
"Documentation": "https://github.com/gordthompson/sqlalchemy-access/wiki",
"Homepage": "https://github.com/gordthompson/sqlalchemy-access",
"Source": "https://github.com/gordthompson/sqlalchemy-access",
"Tracker": "https://github.com/gordthompson/sqlalchemy-access/issues"
},
"split_keywords": [
"sqlalchemy",
"microsoft",
"access"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "ab23ab5a62f9ff084dedfbe4d9b737278c9eb59f158f36e7d26df24aca2ec452",
"md5": "2e87153712e4ec55da352ee48f14c8d7",
"sha256": "6dd7968c724c829f67fef77fa069c686ccae04ea44620a39f608f2075c758254"
},
"downloads": -1,
"filename": "sqlalchemy_access-2.0.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "2e87153712e4ec55da352ee48f14c8d7",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 13964,
"upload_time": "2023-05-26T16:27:12",
"upload_time_iso_8601": "2023-05-26T16:27:12.262615Z",
"url": "https://files.pythonhosted.org/packages/ab/23/ab5a62f9ff084dedfbe4d9b737278c9eb59f158f36e7d26df24aca2ec452/sqlalchemy_access-2.0.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "533f5766d698b5e61a083905a903fcae6c2045e4262b0f2cbe59193c5da7ea80",
"md5": "7daae177076c41aa5cb597ab14f1ae33",
"sha256": "61b577dddc7975f64a567a711105450f56a1d5057e7f0ef1c5772b62a7bc2b1c"
},
"downloads": -1,
"filename": "sqlalchemy-access-2.0.2.tar.gz",
"has_sig": false,
"md5_digest": "7daae177076c41aa5cb597ab14f1ae33",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 17660,
"upload_time": "2023-05-26T16:27:15",
"upload_time_iso_8601": "2023-05-26T16:27:15.125025Z",
"url": "https://files.pythonhosted.org/packages/53/3f/5766d698b5e61a083905a903fcae6c2045e4262b0f2cbe59193c5da7ea80/sqlalchemy-access-2.0.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-05-26 16:27:15",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "gordthompson",
"github_project": "sqlalchemy-access",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "sqlalchemy-access"
}
JSON
