Jen,

I usually use APPEND FROM when possible. I just find that it's easier and that the code is more readable. I'll use LLFF if it isn't separated in a nice way. For example, a report to a file where you have to ignore headers and such.

I've never run speed tests, but it seems like APPEND FROM would usually be faster because you have far fewer lines for the interpeter to deal with.

>So, most of what we use FPW2.x for round here is data conversion. We get .SDF, .XLS and .TXT files from various places, convert the data and send it on. Some of it is coming from our mainframe & going to customers, some is coming from customers heading for our mainframe.
>
>In these circumstances my preference is to use the low level file functions to read each record (fixed length records) then validate, break it up and convert it and write it out in its final form (either .DBF, .TXT, or .XLS)
>
>My predecessor has been importing to a temporary .DBF, then reading this back, doing the data conversion and writing out the final file.
>
>Does anyone have any clue as to which is more efficient? No reason other than curiousity. I've done scads of data conversion in my career and almost always done it this way --even in dBASE, though at times I did have to resort to useing BASIC...
>
>Jen