>Can someone tell me what had I done wrong below:
>
>select 1
>use table1
>
>select 1
>append from textfile type delimited with tab
>
>
>use table2 exclusive
>index on f_fname+f_lname tag lastname
>
>select 1
>
>scan for .not. seek(f_fname+f_lname, table2)
> scatter fields like * to t_array
> select table2
> append from array t_array
> release t_array
>endscan
>
>close database
>use
>
>everything going ok on table1 which I can appending the text file. But in table2 I can't append any record over from table1 (table1 is alway empty)
>
>Any idea!!
Sam, you're using table2 on top of table1
try this: before using table2...SELECT 0
Matt McDonnell
...building a better mousetrap with moldy cheese...