Export of Date from Excel to Access

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.
 
J

John Nurick

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.
 
Top