Exporting from Access97 to Excel97

[Eamonn]

When exporting a query result to Excel the date field
format gets automatically changed (in some cases!) from
dd/mm/yy to mm/dd/yy. How to prevent this?

Thanks
Eamonn

 

[John Nurick]

Hi Eamonn,

One way is to format the Excel cells with the date format you want.