IIRC, it's long standing bug or feature of APPEND TYPE CSV. You can use TYPE DELIMITED to avoid this problem
APPEND FROM fubar.txt TYPE DELIMITED
>when I do an append from
type csv with date fields like:
>
>1/12/2003
>
>the date ends up 1/02/0003 in teh dbf
>
>The code below illustrates this... Any idea how to make the append work "right"? I have a cheesy work around in place where I modify the actual file first... but....
>
>>CREATE CURSOR fubar (test d)
>TEXT TO lcFubar
>1/1/2003
>2/02/2003
>3/12/2003
>10/12/2003
>11/2/2003
>ENDTEXT
>
>STRTOFILE( lcFubar, "fubar.txt",0)
>
>APPEND FROM fubar.txt TYPE csv
>BROWSE
--sb--