I did not know about FGET and FOPEN. Still new to everything. But I would think that would take extra time in the process to verify each record to see if it already exists.

>Why don't you use FOPEN to open your text file, then a serie of FGETS calls to retrieve a record at a time?
>
>Jaime
>
>>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!!