How to export excel table and date column format to be dd/mmm/yyyy?

[fluffyvampirekitten]

How can I export acess table into excel file?
Another problem is that my table date column is in this format - 23/Jan/1983 12:00:00 AM

I would like to extract it without the time , only dd/mmm/yyyy.



Any ideas ?
Thanks in advance

[ranman256]

In your query, make a field: format([dateFld],"dd/mmm/yyyy") as MyDate


export in macro with:
transferspreadsheet

[fluffyvampirekitten]

Should I Edit the query thru "Record Source" of my report ?