Are you sure that you're using TYPE XL5 in COPY TO? You'll get exported as "08-Mar-2006" with TYPE XLS.

>When i export to excel, the date fields get formatted as in the default for excel, in my case in format "Mar 8, 2006". I tried running .Range('S:S').NumberFormat='dd-mm-yyyy' for the date fields, but then i just saw in the debugger they come as "08-Mar-2006", so the CTOD on this fails ( it just gives me empty dates now ).
>