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