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

Carl Karsten carl at personnelware.com
Mon Oct 4 15:52:34 CEST 2010

On Sun, Oct 3, 2010 at 9:25 PM, 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;

Sounds like the error should read "not an sqlite db"

I am guessing you are trying to use the sqlite3 code to write to an Access db.

Is there an access app that still needs to use the db?  If not, then
you can create an sqlite db.

Carl K

More information about the DB-SIG mailing list