Microsoft Access read from linux python

[Cameron Laird]

In article <d3c9c04.0310290828.302971e6 at posting.google.com>,
Mark Carter <cartermark46 at ukmail.com> wrote:
>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.
			.
			.
			.
You can also get an ODBC driver, and run a Linux-hosted ODBC
client.  I haven't done it with Python, but it ought to be 
straightforward.  Alex has probably seen at least the parts
of such an arrangement working.
-- 

Cameron Laird <claird at phaseit.net>
Business:  http://www.Phaseit.net