>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
"In three words I can sum up everything I've learned about life : it goes on." - R. Frost
Amanda Brown
Supervisor/Programmer