Of course after you issue FGETS, you have a string with all the record, then you have to parse this string for the fields you need, and do of course validation ( i.e find if records already exist etc... ) as needed.
This method is the way to go if you can't create temp tables or cursors and the structure of your table is different than the one from the text file you are trying to import, otherwise, as Cetin proposed, just use APPEND FROM...
Cheers,
Jaime
>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!!
Why do programs stop working correctly as soon as you leave the Fox?