Analyze Access query in Excel

O

Orencio

I have a time-of-day field in an Access select query. It reads the time of
day in both AM and PM. When I analyze this data in Excel, it appears as 00
Jan 00. I know how to eventually correct this in Excel, but my question is
how can I protect the original integrity of the time data, as it appears in
Access, when I am in Excel? (withoout going through all the steps in Excel to
correct this).
Thanks for any response.,
Orencio
 
L

Larry Linson

I have a time-of-day field in an
Access select query....
When I analyze this data in Excel,
it appears as 00 Jan 00. I know
how to eventually correct this in
Excel, but my question is how
can I protect the original integrity
of the time data, as it appears in
Access, when I am in Excel?
Click to expand...

Because there is no field type specific to Time in Jet databases (the
default used with Access), chances are that you are only populating the time
values of a Date-Time field, which is not being properly translated by
Excel.

A Date-Time value with a date of "zero" in Access is 31 Dec 1899, if I
recall correctly.

I am not at all sure what you mean by "protect the original integritey of
the time data, as it appears in Access". In Access, it would either be
formatted for display correctly by default, or would be a simple matter of
specifying a format.

Larry Linson
Microsoft Access MVP
 
Top