[DB-SIG] Cookbook for Python access to Access?

[Vernon Cole]

I can't test this right now, but it looks like one may be able to get that
information from a table called "dbf.databases".
Check out the documentation in
http://technet.microsoft.com/en-us/library/cc805477.aspx particularly
chapter 2.
   I note where it says: "To get a list of the objects in a database, you
iterate through each Collection object. The following example iterates
through each TableDef, QueryDef, Relation, and Container object in a
database, and prints the object name to the Debug window."Followed by a VB
example. If you can work out how to do that retrieval in SQL you will have
it.

Let us know what works, if it works.
--
Vernon

On Thu, Oct 7, 2010 at 1:57 PM, Goldsmith, David <dgol461 at ecy.wa.gov> wrote:

> Thanks, Vernon.  I did as you suggest, including visiting
>
> http://www.python.org/dev/peps/pep-0249/
>
> I still don't see how to return a list of tables available in the DB one
> has connected to.
>
> I can't believe no one has ever needed to do this, yet all the replies
> I'm getting/examples I'm being referred to/methods I read about would
> seem to indicate that such an operation is generally not supported by
> the DB model--is that correct?
>
> DG
>
> -----Original Message-----
> From: Vernon Cole [mailto:vernondcole at gmail.com]
> Sent: Thursday, October 07, 2010 10:44 AM
> To: Goldsmith, David; DB-SIG @ Python.org
> Subject: Re: [DB-SIG] Cookbook for Python access to Access?
>
> please pardon slowness, brevity & typos ... am on vacation & using
> Windows Mobile...
>  step 1) load pywin32 from sourceforge.
>  step 2) look in your Python site-packages/adodbapi/test folder for
> example.
> You can read or update ACCESS db using normal SQL statements and
> Python api calls.
>
> On 10/3/10, Goldsmith, David <dgol461 at ecy.wa.gov> wrote:
> > Hi!  I'm relatively new to DB's, though not to Python.  I simply need
> to
> > learn how to programmatically put data--obtained using a Python
> > script--into an existing Access DB.  I've searched and I've searched,
> > found a few brief examples of how to connect--using, e.g.,
> sqlite3--but
> > when I execute a query, I'm told the file I've connected to is either
> > encrypted or not a DB; it may be the former (I don't know how to tell
> > for certain, but I can access it using MATLAB's database toolbox w/out
> > any explicit decryption), but it definitely is a DB.  Can anyone refer
> > me to a relevant cookbook or pretty complete example set?  Thanks!
> >
> >
> >
> > --------------------------------------
> > David Goldsmith
> > Washington State Department of Ecology
> > Environmental Assessment Program
> > Modeling and Information Support Unit
> > 300 Desmond Drive  | P.O. Box 47600
> > Lacey, WA  98503   | Olympia, WA  98504-7600
> > Tel:     (360) 407-6194
> > Fax:     (360) 407-6884
> > Email:   david.goldsmith at ecy.wa.gov
> <mailto:david.goldsmith at ecy.wa.gov>
> > Station: C2D-59
> > Web:     http://www.ecy.wa.gov/programs/eap/
> > <http://www.ecy.wa.gov/programs/eap/>
> >
> >
> >
> >
> _______________________________________________
> DB-SIG maillist  -  DB-SIG at python.org
> http://mail.python.org/mailman/listinfo/db-sig
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20101010/96d0d321/attachment.html>