update/insert access database using python

Question

Is it possible in python by which I can write a simple .py script to update my access database records or insert new one if any i have on behalf of me? new records are to be pulled from Excel and pushed to be in the database.

MS-Access2010 i am using.

Thanks,

Community · Accepted Answer · 2017-05-23 12:12:34Z

1

It's definitely possible. You'll probably want to do it with the comtypes module, which allows communication between Windows processes using the Component Object Model (COM).

Here's an example of a script that does that posted in another question.

Getting the information out of Microsoft Excel can be done with a lot of modules, but one I've had success with is openpyxl. Some examples of reading Excel workbooks with it can be found here.

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Jan 6, 2013 at 22:07

Fredrick Brennan

7,3533 gold badges35 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Arup Rakshit Over a year ago

Shall i need to install using easy_install comtypes or it is in stdlib?

Fredrick Brennan Over a year ago

Neither of them are stdlib, you should install them using pip and a virtualenv if you prefer.

Arup Rakshit Over a year ago

openpyxl i have installed already! now i need the one comptypes. but any documentation of that module you would like to share please?

Collectives™ on Stack Overflow

update/insert access database using python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related