CREATE CURSOR crsImport (fld1 C(20), fld2 N(10))
append from mytext.txt delimited
>
>I have a text file of the following format
>
>
>ABC3333, 23
>FDJFDDF, 0
>HFHFF, 5
>
>
>Basically the text file has two values in each row, one character and one numeric. I want to create a cursor with two fields, one character and one numeric (e.g. mycursor (fld1 c(20), fld2 n(10,0)))
>
>Then I want to append the content of the text file into the cursor.
>When I do it using the syntax
>
>
>append from mytext.txt sdf
>
>
>the entire row goes into the first field (fld1). Is it possible to call APPEND FROM and make it put each segment of the row in the appropriate field?
>
>Thank you in advance for any help.
--sb--