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

[Goldsmith, David]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20101003/41b2548b/attachment.html>