Import MDB table to ACCDB using PYTHON

Question

I am looking for a way to mimic the "Get External Data" in Access 2007 (accdb) using Python. I am trying to import data from a MDB to a ACCDB. Basically I don't want to do this manually each time, but incorporate it into my Python workflow.

May be of interest: stackoverflow.com/questions/2559659/…

Fionnuala
– Fionnuala

2012-07-20 20:49:39 +00:00
Commented Jul 20, 2012 at 20:49 — Fionnuala
– Fionnuala, Commented Jul 20, 2012 at 20:49
operating system is Windows 7

dklassen
– dklassen

2012-07-24 17:22:15 +00:00
Commented Jul 24, 2012 at 17:22 — dklassen
– dklassen, Commented Jul 24, 2012 at 17:22

AndyG · Accepted Answer · 2014-03-12 18:05:14Z

0

Assuming you are on a Windows-machine:

You can automate the "Get External Data"-task by using VBA. Dive into the documentation of the TransferX (TransferText...) methods of the DoCmd-Object in VBA. So before using Python, I would recommend you should program a working VBA-solution for your task.

After that, you can try to use the Win32 Extensions for Python. These offer some COM-Interop classes you could use. Probably this piece of code in Python would be the starter for you:

import win32com.client
acc = win32com.client.Dispatch("Access.Application")
...

With this at hand you should be able to transfer your VBA-Code to Python.

edited Mar 12, 2014 at 18:05

AndyG

41.4k8 gold badges122 silver badges155 bronze badges

answered Aug 23, 2012 at 9:40

Benjamin Brauer

3781 gold badge5 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Import MDB table to ACCDB using PYTHON

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related