How can I access data from MS Access?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Finger.Octopus@gmail.com
    #1

    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.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)

    Tags: None
    • Bruno Desthuilliers
      #2
      Re: How can I access data from MS Access?

      Finger.Octopus@ 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 ?

        Comment

        • Finger.Octopus@gmail.com
          #3
          Re: How can I access data from MS Access?

          On Feb 3, 10:27 pm, Bruno Desthuilliers
          <bdesth.quelque ch...@free.quel 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.

            Comment

            • Peter Otten
              #4
              Re: How can I access data from MS Access?

              Finger.Octopus@ 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

                Comment

                • Bruno Desthuilliers
                  #5
                  Re: How can I access data from MS Access?

                  Peter Otten a écrit :
                  Finger.Octopus@ 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.

                    Comment

                    • Ben Finney
                      #6
                      Re: How can I access data from MS Access?

                      Bruno Desthuilliers <bdesth.quelque chose@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

                        Comment

                        • Andy Dingley
                          #7
                          Re: How can I access data from MS Access?

                          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.

                            Comment

                            • BartlebyScrivener
                              #8
                              Re: How can I access data from MS Access?

                              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


                                Comment

                                Previous template Next
                                Working...