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