Import a .mdb file into Python

709 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 best solutions below

0
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.