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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 25 Nov 2004 06:09 GMT

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

Reply to this Message

John Nurick - 25 Nov 2004 07:23 GMT

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")

>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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message