I am using a macro to TransferSpreadSheet the source is a local table in same data base, I have tried every option of Excel available in the drop down, I export to available drive in my network. What happens is that some of the date fields do not export, some do some don't. When I run the export without using a macro I do not loose the date fields. Any idea how I can get the macro export to work?