- install Microsoft Office, version > 2007, 64bit required
- install Python3, install anaconda
- Create Virtual env,with 'pandas 'and 'pypyodbc 'package installed
- install mdbtools(tested on Ubuntu18.04)
- using converter.py convert data from mdb to sqlite database(Data preprocess)
from converter import Converter
converter = Converter(mdbpath)
converter.mdb2sqlite()