Skip to main content

Access database (*.mdb, *.accdb) parser

Project description

AccessDB Parser (Pure Python)

Microsoft Access (.mdb / .accdb) database files parser. The parsing logic is fully written in python and works without any external binary dependencies.

Installing

Use pip: pip install access-parser

Or install manually:

git clone https://github.com/ClarotyICS/access_parser.git
cd access_parser
python3 setup.py install

Demo

asciicast

Usage Example

from access_parser import AccessParser

# .mdb or .accdb file
db = AccessParser("/path/to/mdb/file.mdb")

# Print DB tables
print(db.catalog)

# Tables are stored as defaultdict(list) -- table[column][row_index]
table = db.parse_table("table_name")

# Pretty print all tables
db.print_database()

Known Issues

This library was tested on a limited subset of database files. Due to the differences between database versions and the complexity of the parsing we expect to find more parsing edge-cases.

To help us resolve issues faster please provide as much data as you can when opening an issue - DB file if possible and full trace including log messages.

Thanks

Project details


Download files

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

Source Distribution

access_parser-0.0.6.tar.gz (17.7 kB view details)

Uploaded Source

File details

Details for the file access_parser-0.0.6.tar.gz.

File metadata

  • Download URL: access_parser-0.0.6.tar.gz
  • Upload date:
  • Size: 17.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.0.1 CPython/3.10.12

File hashes

Hashes for access_parser-0.0.6.tar.gz
Algorithm Hash digest
SHA256 4fe1eb197cd49fa0b8ac02320d8dd98e07795f6fc01a59061434f50c064b4c69
MD5 d55407121a20f1d9559d0540b8e65b61
BLAKE2b-256 cb8f2eb15ff25f58ae4674737aa3f5d6d7b44fc98d9a14c35f06c221a8950cc9

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page