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.NewADOConnection('access') # mxodbc required
dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\\inetpub\\adodb\
\northwind.mdb;"
conn.Connect(dsn)


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

 

[Finger.Octopus]

(e-mail address removed) a écrit :> How to access data from MS Access? I tried ADOdb for Python but it




"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]

On Feb 3, 10:27 pm, Bruno Desthuilliers

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]

(e-mail address removed) 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.NewADOConnection('access') # mxodbc required
dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\\inetpub\\adodb\
\northwind.mdb;"
conn.Connect(dsn)


(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 ?

 

[Bruno Desthuilliers]

Peter Otten a écrit :

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]

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

 

[Andy Dingley]

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]

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