>>>Exporting a Cursor to a file I use COPY TO FILE TYPE XLS but the problem is that the DATE type fields are not recognized like that in Excel,
>>>any idea?
>>
>>Not sure what you mean when you say that the date fields are not recognized? Are they coming out as character?
>
>Actually I'm not really sure but when I'm in Excel looking at the dates field I can't set the autofilter to select a range of entries. Although the items in the colum appear as 12-jun-99 I can't switch the cells format to date either.
>
>Thank you for any idea Evan.

Instead try (note a "5" not "s")

COPY TO FILE TYPE XL5