Scanning text file itself is not a good idea. However Append command supports expressions and scope. ie :
append from ... for !seek(IDField, 'myRealTable','myIDTag')
Cetin
>Forgot to add that I need to verify the record does not exist in the existing table. I guess a scan could work for that right before the append took place?
>
>
>>>I have an existing table with records. What is the proper method to import text delimited data seperated by pipes? Would it be better to create a temporary table first? I am trying to create this process for users to be able to use this method over Terminal Services. So I figured a cursor would be better than temp table so that there would be no conflicts with directories and overwriting. However, I cannot get this data into a cursor. Please help!! Thanks!!
>>
>>Like :
>>Steven Buchanan|Sales Manager|15
>>?
>>
>>append from myText.txt type delimited with "" with character "|"
>>
>>BTW cursor is better than table IMHO.
>>Cetin