converting a string data to a float value for access database

tedpottel at gmail.com tedpottel at gmail.com
Tue Nov 25 16:37:27 EST 2008


Hi,

I am trying to copy a sql database to a access database using python.
I can copy all the fields, but the date.  I can store a float value in
access data object, ie http://en.wikibooks.org/wiki/JET_Database/Data_types#Dates_and_times

So access uses a float for a date, and mysql databse uses text, I got
the following as the output 2008-11-25 09:59:39.
How can I convert the string 2008-11-25 09:59:39 from mysql to a float
for access??????


-Ted



More information about the Python-list mailing list