> Date: Thu, 7 Oct 2010 16:46:11 -0700 > From: Adrian Klaver <[email protected]> > Subject: Re: [SEAPY] Anyone here use ceODBC w/ MS Access DBs? > To: Seattle Python Interest Group <[email protected]> > > On Thursday 07 October 2010 3:45:15 pm David Goldsmith wrote: >> I'm having a helluva time: >> >> 0) Getting a simple INSERT INTO statement to work; > > I have not worked with particular module before but it follows the Python > Db-api > so something like below should work where fld_1 is string > field(char,varchar,text,etc) and fld_2 is an integer field. > > cur=conn.cursor() > cur.execute("insert into table_name(fld_1,fld_2) values(?,?)",('test',1)) > > For general view of dbapi: > http://www.python.org/dev/peps/pep-0249/ > >> >> 1) Finding a good, reasonably rich example set or "cookbook," esp. one >> geared toward a DB newbie such as myself; > > Python cookbook?: > http://code.activestate.com/recipes/langs/python/tags/database/
Thanks Adrian. Unfortunately, it's now moot: I've been informed that I can't "touch" the DB w/ Python, 'cause it was hard enough convincing our IT security people to let us touch it w/ MATLAB (they wanted only .NET technology to touch it). :-( DG
