Re: Trying to set a date field in a access databse

You should be able to pass a PyTime or datetime.datetime object. Roger <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > I cannot get the following code to work > > import win32com.client > import time > > engine = win32com.client.Dispatch("DAO.DBEngine.36") > db=en

Re: Trying to set a date field in a access databse

On 2008-11-05 21:12, [EMAIL PROTECTED] wrote: > Hi, > I cannot get the following code to work > > import win32com.client > import time > > engine = win32com.client.Dispatch("DAO.DBEngine.36") > db=engine.OpenDatabase(r"testdate2.mdb") > access = db.OpenRecordset("select * from test") > > access.

Re: Trying to set a date field in a access databse

[EMAIL PROTECTED] wrote: > Hi, > I cannot get the following code to work > > import win32com.client > import time > > engine = win32com.client.Dispatch("DAO.DBEngine.36") > db=engine.OpenDatabase(r"testdate2.mdb") > access = db.OpenRecordset("select * from test") > > access.AddNew() > access.Fi