Try without "with":
APPEND FROM test.txt DELIMITED
or
APPEND FROM test.txt DELIMITED with CHARACTER ,


>Hi folks
>
>I'm having a bit of a problem with APPEND FROM and was wondering if its my understanding or a problem with VFP...
>
>I have a test text file with the following
>
>1,2,3
>1,,3
>
>which I want to import into a cursor with fields a,b,c so I do
>
>APPEND FROM test.txt DELIMITED WITH ,
>
>The first line is fine but the second line imports as
>a=1
>b=3
>
>whereas I would have thought (and want) :
>a=1
>b = blank
>c = 3
>
>Basically if there is no value for the field then the text file will just output a comma instead of value and comma.
>
>Its fine if the data is "" delimited
>
>Any ideas would be appreciated...