MySQL Reference Manual for version 3.21.31. You should have a timestamp. Only use double float fields.
Access fails when comparing with single floats.
Set 2 in the options field when connection to MySQL . If you have problems with dates try to select them as strings. Excel does not understand that. Note that this is a bug in Excel because it automaticly converts a string to a time. This would be great if the source was a text file, but this is plain stupid when the source is a ODBC connection which reports exact types for each column.