# polars_access_mdbtools
A library for reading tables from an Access database into Polars dataframes, using mdbtools
## What is this?
A tiny, `subprocess`-based tool for reading a
[MS Access](https://products.office.com/en-us/access)
database (`.mdb`, `.accdb`, `.rdb`) as a [Python Polars Dataframe](https://docs.pola.rs).
## Installation
To read the database, this package thinly wraps
[MDBTools](https://github.com/mdbtools/mdbtools).
If you are on `macOS`, install it via [Homebrew](http://brew.sh/):
```sh
$ brew install mdbtools
```
If you are on `Debian`, install it via apt:
```sh
$ sudo apt install mdbtools
```
If you are on `Windows`, it's a little tougher. Install `mdbtools` for [Windows](https://github.com/lsgunth/mdbtools-win). Manually add to PATH.
1. Download the mdb-tools files from Windows link above. Visit the Releases section, then download the part that says "Source Code (zip)".
2. Extract that to somewhere like `C:/bin/mdbtools-win/mdbtools-win-1.0.0`.
3. Follow these instructions to [add that folder to your environment path](https://linuxhint.com/add-directory-to-path-environment-variables-windows/) (Method 1, but use the path to the mdbtools executable files).
4. Restart your computer or just close and re-open the program you're running it from. You can test that it works by opening a terminal and running `mdb-tables --help` and see that it doesn't fail.
Finally, on all OS's:
```sh
$ pip install polars_access_mdbtools
```
## Example Usage
```python
import polars as pl
import polars_access_mdbtools as pl_access
file_path = "path_to_file.mdb"
print(pl_access.list_table_names(file_path))
df: pl.DataFrame = pl_access.read_table(file_path, table_name="your_table_name")
```
## Acknowledgements
This code is based heavily on [jbn's `pandas_access` library](https://github.com/jbn/pandas_access).
## Contributing
Please Star this repo.
Please submit bug reports as GitHub Issues. Feel free to submit a PR to fix an issue!
Raw data
{
"_id": null,
"home_page": null,
"name": "polars_access_mdbtools",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.11",
"maintainer_email": null,
"keywords": "access, database, dataframe, mdbtools, polars",
"author": "DeflateAwning",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/8f/1e/a94b206d29ae73def6b342d5ecf205170bbb33165f7ba692df99dff993f2/polars_access_mdbtools-0.1.1.tar.gz",
"platform": null,
"description": "# polars_access_mdbtools\nA library for reading tables from an Access database into Polars dataframes, using mdbtools\n\n## What is this?\n\nA tiny, `subprocess`-based tool for reading a \n[MS Access](https://products.office.com/en-us/access) \ndatabase (`.mdb`, `.accdb`, `.rdb`) as a [Python Polars Dataframe](https://docs.pola.rs).\n\n## Installation\n\nTo read the database, this package thinly wraps \n[MDBTools](https://github.com/mdbtools/mdbtools).\n\nIf you are on `macOS`, install it via [Homebrew](http://brew.sh/):\n\n```sh\n$ brew install mdbtools\n```\n\nIf you are on `Debian`, install it via apt:\n```sh\n$ sudo apt install mdbtools\n```\n\nIf you are on `Windows`, it's a little tougher. Install `mdbtools` for [Windows](https://github.com/lsgunth/mdbtools-win). Manually add to PATH.\n1. Download the mdb-tools files from Windows link above. Visit the Releases section, then download the part that says \"Source Code (zip)\".\n2. Extract that to somewhere like `C:/bin/mdbtools-win/mdbtools-win-1.0.0`.\n3. Follow these instructions to [add that folder to your environment path](https://linuxhint.com/add-directory-to-path-environment-variables-windows/) (Method 1, but use the path to the mdbtools executable files).\n4. Restart your computer or just close and re-open the program you're running it from. You can test that it works by opening a terminal and running `mdb-tables --help` and see that it doesn't fail.\n\nFinally, on all OS's:\n```sh\n$ pip install polars_access_mdbtools\n```\n\n## Example Usage\n\n```python\nimport polars as pl\nimport polars_access_mdbtools as pl_access\n\nfile_path = \"path_to_file.mdb\"\nprint(pl_access.list_table_names(file_path))\n\ndf: pl.DataFrame = pl_access.read_table(file_path, table_name=\"your_table_name\")\n```\n\n## Acknowledgements\n\nThis code is based heavily on [jbn's `pandas_access` library](https://github.com/jbn/pandas_access).\n\n## Contributing\n\nPlease Star this repo. \n\nPlease submit bug reports as GitHub Issues. Feel free to submit a PR to fix an issue!\n\n",
"bugtrack_url": null,
"license": null,
"summary": "A library for reading tables from an Access database into Polars dataframes, using mdbtools",
"version": "0.1.1",
"project_urls": {
"Homepage": "https://github.com/DeflateAwning/polars_access_mdbtools",
"Issues": "https://github.com/DeflateAwning/polars_access_mdbtools/issues",
"License": "https://github.com/DeflateAwning/polars_access_mdbtools/blob/main/LICENSE"
},
"split_keywords": [
"access",
" database",
" dataframe",
" mdbtools",
" polars"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "2d0c479b63e182bb2180b4c64e780609ba5c7f36b533d3431d4d58222d1c2f71",
"md5": "50b4be67984390265a8408667b57ec32",
"sha256": "955dc67e7635bb1e71bfe0e1bc3b52d0281e934eb46c85c4000d0ec64d40e45b"
},
"downloads": -1,
"filename": "polars_access_mdbtools-0.1.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "50b4be67984390265a8408667b57ec32",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.11",
"size": 6288,
"upload_time": "2025-10-21T02:03:19",
"upload_time_iso_8601": "2025-10-21T02:03:19.555446Z",
"url": "https://files.pythonhosted.org/packages/2d/0c/479b63e182bb2180b4c64e780609ba5c7f36b533d3431d4d58222d1c2f71/polars_access_mdbtools-0.1.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "8f1ea94b206d29ae73def6b342d5ecf205170bbb33165f7ba692df99dff993f2",
"md5": "c73c6b309fc8daf8340c82e5fdc526ff",
"sha256": "5e173fb6246d6049da76613623b27759bb0a76d034297628b11198b2725a9a82"
},
"downloads": -1,
"filename": "polars_access_mdbtools-0.1.1.tar.gz",
"has_sig": false,
"md5_digest": "c73c6b309fc8daf8340c82e5fdc526ff",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.11",
"size": 25029,
"upload_time": "2025-10-21T02:03:20",
"upload_time_iso_8601": "2025-10-21T02:03:20.280973Z",
"url": "https://files.pythonhosted.org/packages/8f/1e/a94b206d29ae73def6b342d5ecf205170bbb33165f7ba692df99dff993f2/polars_access_mdbtools-0.1.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-10-21 02:03:20",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "DeflateAwning",
"github_project": "polars_access_mdbtools",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "polars",
"specs": []
}
],
"lcname": "polars_access_mdbtools"
}
JSON
