How to set the date value in a access dadat base

tedpottel at gmail.com tedpottel at gmail.com
Fri Mar 20 19:33:01 EDT 2009


Hi,
I got the following code

           access.Edit()

            access.Fields("customer").value= row["customer"]
            t=row["time"]
            print t

            access.Fields("Time").value=0.0 # time is a float value
            access.Fields("phrase").value= row["phrase"]
            access.Fields("key_word_phrase").value = row
["key_word_phrase"]
            access.Fields("from_server").value = row["from_server"]
            access.Fields("path_name").value = row["path_name"]
            id = row["PageID"]
            print id
            g=str(id)
            k=int(g)
            access.Fields("PageID").value=k
            access.Fields("server_name").value = row["server_name"]
            access.Fields("file_name").value = row["file_name"]

            access.Update()

It seems like the dat takes in a float.  If I want to set it to a
spefic date, like 3/6/2009, how would I do it?

-Ted



More information about the Python-list mailing list