Tony,
One more idea:
CREATE CURSOR FirstCursor(Field1 C(10), Field2 C(10))
APPEND FROM Temp.txt TYPE SDF
COPY TO ARRAY laMyArray
CREATE CURSOR SecondCursor(Date1 D, Date2 D)
APPEND FROM ARRAY laMyArray
The array is pretty flexible with data types.
>I have set century on and set date to american and trying to append a text file with two fields like:
>
>01/01/200002/01/2000
>02/01/200002/02/2000
>
>into a table with 2 date fields
>d_start d (8)
>d_end d (8)
>
>and issue the command: append from temp.txt type sdf.
>
>VFP results with :
>
>rec #1
>d_start = 01/01/0020
>d_end = 01/02/2000
>
>rec #2
>
>d_start = 02/01/0020
>d_end = 02/02/2000
>
>Why is the first field turns into 0020 as year and 2000 on the second record?
>
>Help appreciated.