Hello.
I have a MS Access database. Every month, I need to export 100+ excel files manually based on different criteria from this database.
I am wondering if it is possible to let Python distinguish, pick, and export data from MS Access automatically?
I already have pyodbc installed and have MS Access connected with Python IDLE. Now I am able to read data through Python IDLE. Am I on the right way? If not, please explain.
Thanks!
1 Like
Assuming you’re on Windows with Office installed, pyodbc can connect to an Access file through the ODBC interface. You can find more information on the project wiki: https://github.com/mkleehammer/pyodbc/wiki
There are a few alternatives if you don’t have Office and/or Windows, but they are much more obscure (I don’t have experience with any of them either).
1 Like
I have pyodbc installed already. I will keep studying it.
Thank you for your advises.
1 Like