I want to read the contents of a series of MS Access databases from a 64bit Python application under Windows.
The machine on which I want to do this has 32bit versions of various MS Office applications installed (but not Access). This prevents my loading the 64bit versions of the Microsoft Access Database Engine 2010 Redistributable.
That would seem to prevent me using pyodbc or adodbapi to access the files, as they would appear to need the 64bit database driver installed.
At the moment I have sidestepped this by reading the MDB files into a Postgresql database using a 32bit application, and then accessing the Postgresql data from the 64bit Python application.
Any ideas for something more direct?