exporting date fields to excel

  • Thread starter Thread starter ash
  • Start date Start date
A

ash

Hi
I'm trying to export tables to excel, so that I may use
STAT Transfer to create .dta files for analysis in STATA.
The date fields are not exporting as dates. Fields in the
database are formatted as short date with an input mask
99/99/9999.

Is there a way to export these fields with the date fields
intact, or can I code the date fields differently in the
database so they will export correctly?

Thank you very much!
ash
 
Hi Ash,

Assuming that these are Access date/time fields and that they are
appearing as numbers in Excel (e.g. I'm writing this at 37964.2714, or
0630 on 9 December 2003), just format the Excel cells with whatever date
or time format you like.

If this isn't the problem, please explain more clearly.
 
Back
Top