>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.