Search code examples
pythonms-accesspyodbcmdbtools

How to Read .mdb file using python 64 bit?

i am getting filenot found error in pandasaccess

MDB tools are also not working

mdb-tables : The term 'mdb-tables' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + mdb-tables .\Classes\Test-results.mdb

Pyodbc is working only on win 32 bit

similar one here How to read from a 32 bit .mdb with 64 bit python and odbc driver

But still no answer for both

Solution

  • pandas_access is a thin wrapper around MDBTools and MDBTools is really only intended for non-Windows platforms.

    If you want to use pandas to work with an .mdb file in 64-bit Python under Windows then you need to install the 64-bit version of the Access Database Engine and use the sqlalchemy-access dialect for SQLAlchemy.