Read MS Access 97 *.mdb files with python??

[Gordon McMillan]

Quinn Dunkan wrote:

> ... I have databases in
> Access. Currently, they are converted to cvs and read into mysql,
> which then serves them to python via iODBC + mxODBC.  Of course, I
> would much rather have Access talk to mysql directly and be just a
> front-end for mysql, and the iODBC stuff seems to imply this can be
> done...  But I still can't figure out how to get Access to do
> this...  Anyone have a similar setup?

It's been years since I did this, but as I recall, you set up a 
"System DSN" from Control Panel | ODBC for the remote DB. Then, in 
Access, you use File | External Data | Link Tables and point to the 
System DSN you just configured. I think this requires a "dummy" 
Access mdb. There may be other ways to do it, but this is what looks 
familiar as I poke around in Access's menus.

- Gordon