G Guest Nov 25, 2004 #1 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
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 Nov 25, 2004 #2 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")
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")
