470,811 Members | 1,220 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,811 developers. It's quick & easy.

How can I access data from MS Access?

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)

Feb 3 '07 #1
7 1887
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.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 ?
Feb 3 '07 #2
On Feb 3, 10:27 pm, Bruno Desthuilliers
<bdesth.quelquech...@free.quelquepart.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.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 ?
I havn't said "doesn't work", I rather doesn't seem to work.

Feb 3 '07 #3
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
Feb 3 '07 #4
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.

Feb 4 '07 #5
Bruno Desthuilliers <bd*****************@free.quelquepart.frwrites:
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

Feb 4 '07 #6
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.

Feb 5 '07 #7
On Feb 5, 4:52 am, "Andy Dingley" <ding...@codesmiths.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
Feb 6 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

63 posts views Thread by Jerome | last post: by
9 posts views Thread by WalterR | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
9 posts views Thread by Tony Lee | last post: by
17 posts views Thread by DaveG | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
21 posts views Thread by nihad.nasim | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.