>I've never encountered an APPEND FROM ... TYPE SDF not actually pulling all of the data into the table.
>
>Are you appending across a slow network link, or from a local disk (is it possible that the append is being interrupted)?
>
>When you multiply the number of records appended by the length of the records (plus one byte for deletion flag) - how much does this differ from the size of the file as reported by Windows Explorer (right mouse, properties, to get actual byte size)?
>

I was appending from a network connection but switched to my hard drive because I also thought it might be getting interrupted. Not the case here. Still only get a part of the .txt file.

The difference in byte size is 169,699,042 bytes. I have the .txt file being 218,126,554 and the table 48,427,512 on this particular file