Import a .mdb file into Python

704 views Asked by At

I want to import a .mdb file into Python (I'm using Jupyter). My file name is PIF.mdb and i want a table called ValuesXYZ. Do anyone know what code works for this? I teste a lot of codes but they doesn't worked. So grateful, Henrique.

1

There are 1 answers

0
lite_light On

Unfortunately, you cannot directly read the table. .mdb is database file and not tables. You need to connect to it first, via pyodbc for example.

This SO thread explains it really well.