Microsoft Access read from linux python

[Mark Carter]

David ROBERT <david at ombrepixel.com> wrote in message news:<bno3nf$1ftp$1 at biggoron.nerim.net>...
> Hello,
> 
> I need to read data from a MS Access database.
> The program (reader) is installed on a linux box and
> is written in python langage.
> The database is MS Access 2002 installed on a Win XP box
> networked with the linux box.
> 
> Is it possible for python/linux to read data from MS Access
> Database ?
> 
> I've read a lot of things about mxODBC, iODBC and so on,
> but I'm still very confused, It looks like it is _not_
> possible.
> 
> Ideas ? experiences ?

AFAIK, Python IS able to access MS Access 2002 from Windows. You will
need to install Python on Win XP, and install Mark Hammond's win32all.
It can interface with any Microsoft COM component, which includes MS
Office programs.

You will need to write a Python script on Win XP that interrogates an
Access database. Then you'll need to write some Python networking
stuff to connect Win XP to Linux (maybe using XML-RPC).

This assumes that you can't just export Access to a more open
database, and ditch Access.


> 
> David ROBERT.