>>>>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


I just got to the same point.
It works great.
Thank you Evan.