How can I access data from MS Access?

[Finger.Octopus]

How to access data from MS Access? I tried ADOdb for Python but it
doesn't seems to work.

Even the official examples dont work, like this one:

import adodb
conn = adodb.NewADOCon nection('access ') # mxodbc required
dsn = "Driver={Micros oft Access Driver (*.mdb)};Dbq=d: \\inetpub\\adod b\
\northwind.mdb; "
conn.Connect(ds n)
(I have downloaded mxodbc, but still it doesn't works)

[Bruno Desthuilliers]

Fi************@ gmail.com a écrit :

How to access data from MS Access? I tried ADOdb for Python but it
doesn't seems to work.

Even the official examples dont work, like this one:

import adodb
conn = adodb.NewADOCon nection('access ') # mxodbc required
dsn = "Driver={Micros oft Access Driver (*.mdb)};Dbq=d: \\inetpub\\adod b\
\northwind.mdb; "
conn.Connect(ds n)
(I have downloaded mxodbc, but still it doesn't works)

"doesn't work" is the worst possible description of a problem. Did it
print out some insults in a foreign language ? wipe out your HD ? Else ?

[Finger.Octopus]

On Feb 3, 10:27 pm, Bruno Desthuilliers
<bdesth.quelque [e-mail] quepart.frwrote :

Finger.Octo...@ gmail.com a écrit :How to access data from MS Access? I tried ADOdb for Python but it

doesn't seems to work.

Even the official examples dont work, like this one:

import adodb
conn = adodb.NewADOCon nection('access ') # mxodbc required
dsn = "Driver={Micros oft Access Driver (*.mdb)};Dbq=d: \\inetpub\\adod b\
\northwind.mdb; "
conn.Connect(ds n)

(I have downloaded mxodbc, but still it doesn't works)

"doesn't work" is the worst possible description of a problem. Did it
print out some insults in a foreign language ? wipe out your HD ? Else ?

I havn't said "doesn't work", I rather doesn't seem to work.

[Peter Otten]

Fi************@ gmail.com wrote:

On Feb 3, 10:27 pm, Bruno Desthuilliers

>"doesn't work" is the worst possible description of a problem. Did it
print out some insults in a foreign language ? wipe out your HD ? Else ?

I havn't said "doesn't work", I rather doesn't seem to work.

Bruno, admit that you were wrong. Finger.Octopus is able to give a
description that is even worse than what you deemed possible :-)

Peter

[Bruno Desthuilliers]

Peter Otten a écrit :

Fi************@ gmail.com wrote:

>>On Feb 3, 10:27 pm, Bruno Desthuilliers

>>>"doesn't work" is the worst possible description of a problem. Did it
print out some insults in a foreign language ? wipe out your HD ? Else ?

>>I havn't said "doesn't work", I rather doesn't seem to work.

Bruno, admit that you were wrong. Finger.Octopus is able to give a
description that is even worse than what you deemed possible :-)

Peter, I sadly admit that I was wrong. "Doesn't seem to work" is
effectivly even more useless than "doesn't work". I give up.

[Ben Finney]

Bruno Desthuilliers <bd************ *****@free.quel quepart.frwrite s:

I sadly admit that I was wrong. "Doesn't seem to work" is effectivly
even more useless than "doesn't work". I give up.

+1 QOTW

--
\ "You can't have everything; where would you put it?" -- Steven |
`\ Wright |
_o__) |
Ben Finney

[Andy Dingley]

On 3 Feb, 15:43, Finger.Octo...@ gmail.com wrote:

How to access data from MS Access?

Can you access Access from Access ? from Excel / Visual Basic / SQL
Query? First of all check that the DSN is working and connects to the
back end MDB. This might not be Python's problem.

Secondly check whatever errors you're being returned.

[BartlebyScrivener]

On Feb 5, 4:52 am, "Andy Dingley" <ding...@codesm iths.comwrote:

On 3 Feb, 15:43, Finger.Octo...@ gmail.com wrote:

How to access data from MS Access?

First of all check that the DSN is working and connects to the
back end MDB. This might not be Python's problem.

Secondly check whatever errors you're being returned.

Yes, and then move onto something like this:

http://www.freelance-developer.com/howto_odbcpy

rd

"Give a man a fire and keep him warm for a day. Light a man on fire
and he will be warm for rest of his life."

--Terry Pratchett