CODEWITHSUNDEEP
pythonpython-2.7
Arup Rakshit
Arup Rakshit

Reputation: 118271

update/insert access database using python

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,

Upvotes: 0

Views: 2254

Answers (1)

Fredrick Brennan
Fredrick Brennan

Reputation: 7357

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.

Upvotes: 1

Related Questions