ODBC / DBI help (via Win32 Extensions)

[Brian Fritz]

Benjamin Schollnick <junkster at nospam.rochester.rr.com> wrote:

> 	I've got the read, and most of the "write" functions working
> fine, except when it comes to utilizing the date values...
> I can read and convert the date information into a python readable
> value.... But I can't seem to do an UPDATE or INSERT INTO command
> with a date value inside it.

The following line works great for me with SQL Server 7.0:

mycursor.execute( "update database set date_changed = '19990429 11:20' \
where some_column = 'some_value' " )

Haven't messed with Access, but it should work the same.

Brian