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

[Vernon Cole]

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/>
>
>
>
>