# What is this?
A tiny, `subprocess`-based tool for reading a
database (`.rdb`) as a [Pandas](http://pandas.pydata.org/)
To read the database, this package (thinly!) wraps
[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already
using Pandas, it should be your only installation requirement.
If you are on `OSX`, install it via [Homebrew](http://brew.sh/):
$ brew install mdbtools
$ pip install pandas_access
import pandas_access as mdb
# Listing the tables.
for tbl in mdb.list_tables("my.mdb"):
# Read a small table.
df = pandas_access.read_table("my.mdb", "MyTable")
# Read a huge table.
accumulator = 
for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000):
If you need more power than this, see:
I needed this code in a quick pinch -- I had no access to MS Access, and I had
a single `.mdb` file. If someone with Access would like to create a tiny
database for unit-testing purposes, I'd be much obliged.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.