>>>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
>
>Thanks Matt,
>
>But I still don't understand the concept of this. When I use scan for seek('blah') I had select the alias on which the table I'm comparing right. How come, it doesn't seen to compare the index of two tables???

Sam, that was that point. You weren't comparing two tables. When you used table2, you closed table1. If it's still not working, please post the new code.