how do i export dates prior to 1900 from access to excel

A

Alan

all dates in my access database prior to 1900 are lost when exporting to
excel, unless i set the field to text not date/time
 
J

John Nurick

Hi Alan,

As I understand it this is a limitation of Excel. But you can still use
Date/Time fields in Access. All you have to do is convert the dates to
text as you export them, using a calculated field in a query, e.g.

fDateField: Format([DateField],"dd/mm/yyyy")
 
Top