Working with an Access database in Python on non-Windows platform (Linux or Mac)

by

On Mac OSx and Ubuntu 18.04 you can use pandas_access

From the documentation:

import pandas_access as mdb

db_filename="my_db.mdb"

# Listing the tables.
for tbl in mdb.list_tables(db_filename):
  print(tbl)

# Read a small table.
df = mdb.read_table(db_filename, "MyTable")

On Ubuntu you may need to run:

sudo apt install mdbtools

More Related Contents:

  1. “Data source name not found and no default driver specified” with Access ODBC
  2. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  3. how to catch specific pyodbc error message
  4. How to uninstall Python 2.7 on a Mac OS X 10.6.4?
  5. Getting “Permission Denied” when running pip as root on my Mac
  6. Open document with default OS application in Python, both in Windows and Mac OS
  7. pip installing in global site-packages instead of virtualenv
  8. “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
  9. What do I need to read Microsoft Access databases using Python?
  10. Too many different Python versions on my system and causing problems
  11. Python and OpenSSL version reference issue on OS X
  12. python matplotlib framework under macosx?
  13. Broken references in Virtualenvs
  14. Output pyodbc cursor results as python dictionary
  15. Cross-platform space remaining on volume using python
  16. Can’t load Python modules installed via pip from site-packages directory
  17. Could not install packages due to an EnvironmentError: [Errno 13]
  18. Make python3 as my default python on Mac
  19. MSSQL2008 – Pyodbc – Previous SQL was not a query
  20. Can’t install PIL after Mac OS X 10.9
  21. Why does Python installed via Homebrew not include Tkinter
  22. mysql-python installation problems (on mac os x lion)
  23. How to install two versions of Anaconda (Python 2 and 3) on Mac OS
  24. Switch between python 2.7 and python 3.5 on Mac OS X
  25. How do you install lxml on OS X Leopard without using MacPorts or Fink?
  26. Updating Python on Mac
  27. What is the best way to Install Conda on MacOS (Apple/Mac)?
  28. Python PyQt on macOS Sierra
  29. Setting Mac OSX Application Menu menu bar item to other than “Python” in my python Qt application
  30. How to install NumPy for python 3.3.5 on Mac OSX 10.9

Leave a Comment