[Tutor] Control MS Access with Python

[Will Liu]

Hello.

I am new to Python. I am wondering if it is possible to control MS Access with Python?
I have a MS Access database. Every month, I need to export 100+ excel files from this database manually based on different criteria.
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!

Will Liu
Engineer Assistant | iGeo LLC
3000 Wilcrest Drive, Suite 240 | Houston, Texas 77042 United States
Phone: +1 281 857 2091
E-mail: yichen.liu at igeollc.com