CSV. But when I open the csv file with Excel, that's the format the date fields are in.

>I'm confused. Are you importing from Excel or from CSV file?
>
>>The difference was that the date field in excel was stored as a date instead of text.
>>
>>>>When importing from a csv file, the year portion of the dates are distorted. Example: 01/01/2009 come up as 01/01/0009. Is there a fix for this?
>>>
>>>Works fine for me in the test below. How yours CSV is different?
>>>

>>>TEXT TO lcStr NOSHOW
>>>"Date","String","Int"
>>>01/01/2009,"String1", 15
>>>12/25/2008,"String2", 23
>>>
>>>ENDTEXT
>>>
>>>STRTOFILE(lcStr, "temp.csv")
>>>
>>>CREATE CURSOR Temp (fld1 D, fld2 C(30), Fld3 I)
>>>APPEND FROM "temp.csv" CSV
>>>LOCATE
>>>BROWSE NOWAIT
>>>