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=engine.OpenDatabase(r"testdate2.mdb") > access = db.OpenRecordset("select * from test") > > access.AddNew() > access.Fields("test").value=time.strptime('10:00AM', '%I:%M%p') > access.Update() > > wherer test is a datetime field, > How can I do this??????? > -Ted > > -- > http://mail.python.org/mailman/listinfo/python-list > -- http://mail.python.org/mailman/listinfo/python-list