Export and import DataFrames to Access file (.mdb)

Question

I have 7 tables which I want to read from an Access file (.mdb), then I need to change the values using pandas DataFrame, and then save them again in a new Access file. Do you have any suggestion on how to do that? I am relatively new in python, and any support is highly appreciated.

Answer 1

This may be some help: https://pypi.python.org/pypi/pandas_access

Everything should be straight forward after you're able to load the tables into pandas data frame. Then do the data manipulations you need to and send back to Access.