>>>I have a text file that contains a header record and details record. How do I append the first textfile record into my table using APPEND FROM and how do APPEND FROM the remaining detail records into another table? Or is there a better way? thanks
>>
>>Would APPEND TYPE CSV work for you? It ignores the first record.
>
>My file needs to be brought in as SDF actually. I think capturing my detail record through SDF will work because I can always delete the first record in my DETAIL_TABLE, however; how would I capture the first record which needs to goto HEADER_TABLE? My files are not comma seperated unforunately.
>
>Nick
Yes, you can delete the first (header) record or add FOR condition that will filter it out. For the header record you append into empty cursor and use. After that you can move header record into the table
APPEND SDF FROM (lcFileName) FOR RECNO() = 1
--sb--