Access database (*.mdb, *.accdb) parser
Project description
AccessDB Parser
Microsoft Access (.mdb / .accdb) database files parser. access_parser parsing logic is fully written in python and works without any external binary dependencies.
Installing
git clone https://github.com/ClarotyICS/access_parser.git
cd access_parser
python3 setup.py install
Demo
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 to a file
db.dump_database("/path/to/output/file.txt")
Known Issues
- OLE fields are currently not supported
- Only a subset of memo fields are parsed
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
- This library was made possible by the great work by mdb-tools. The logic in this library heavily relies on the excellent documentation they have https://github.com/brianb/mdbtools
- Huge thanks to Mashav Sapir for the help debugging, CRing and contributing to this project https://github.com/mashavs
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.1.tar.gz
(10.6 kB
view hashes)
Built Distribution
Close
Hashes for access_parser-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 372ae2c08b6f2c8ef8f6fdaf612498a043468fd554295c1a9fc7743e44814ed6 |
|
MD5 | a8a8c4c163693e1983502227f3d5026b |
|
BLAKE2b-256 | 4632cc7eb0a59a1877805ff1832ab0c3f18cb3f6e883264b4b9d17c159e7b638 |