Exporting date/time from Access 2002 to Excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After exporting date/time data from Access 2002 to Excel 2002, the field in
Excel is missing the time portion of the data. For example, "8/7/2002
11:34:46 AM" in Access becomes "8/7/2002" in Excel. This appears to happen
because Excel doesn't have a date/time data type.
 
Check that the cell in EXCEL isn't formatted to just show date. Normally,
the problem we see is the reverse -- exporting a date to EXCEL ends up with
the time component being shown too.
 
Back
Top