Date field becomes a text field

B

Ben

Hi all,

Access 2003, WinXP.
I have query to qeuries from a table with two date fields but when I do:

DoCmd.TransferSpreadSheet acExport, acSpreadsheettypeExcel9, MyQuery,
MyFilePath

The two date fields becomes text fields in Excel with a "'" in front of
each date value. Can you share with me how to mitigate this?

Thanks,

Ben
 
Top