>Hello friends; How can I skip the header of a txt file when doing APPEND FROM?

Some options:

- Change the process that creates the text file to exclude the header row. For example, if it's an Excel CSV, you could Google [excel export to csv without header]
- If the APPEND FROM is working without error but you get a "junk" row at the top, in the target table you could:

GO TOP
DELETE NEXT 1
PACK

- You could create a copy of the original text file, but with the header trimmed out, and APPEND FROM that. Pseudocode:

* Import the original text file to a string with FILETOSTR( )
* Use AT( ) to determine the length of the first text line - find the location of Carriage Return/Line Feed (CRLF) combination i.e. CHR( 13 ) + CHR( 10 )
* Use STRTOFILE( ) to write out the RIGHT( String, LEN( String ) - LEN ( FirstLine) ) portion of the string to a new text file