Export of Date from Excel to Access

  • Thread starter Thread starter Daryl Hageman
  • Start date Start date
D

Daryl Hageman

I need to find a way to solve the following problem. When
the date (Short Date formated) field from Access, is
exported to Excel, it shows up in the Excel workbook as a
long date format (11/29/04 00:00). I need to find a way
to eliminate the time portion of the field.
 
Hi Daryl,

Access exports the date/time values, not the formats applied to the
fields. Just format the Excel cells the way you want them.
 
Back
Top