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