Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

MS Access for SQLAlchemy

Project description

A Microsoft Access dialect for SQLAlchemy.

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 and pyodbc. They are both 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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sqlalchemy-access, version 1.0.3
Filename, size File type Python version Upload date Hashes
Filename, size sqlalchemy_access-1.0.3-py3-none-any.whl (12.4 kB) File type Wheel Python version py3 Upload date Hashes View hashes
Filename, size sqlalchemy-access-1.0.3.tar.gz (13.3 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page