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:vernondc...@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 <dgol...@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.goldsm...@ecy.wa.gov <mailto:david.goldsm...@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@python.org http://mail.python.org/mailman/listinfo/db-sig
