I'm still confused. Where VFP comes in the picture?
>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
>>>>
--sb--