Jim,

Hi,

>How are you importing? Is it through APPEND FROM? Is it using IMPORT? Is it using SELECT?

I'm using a do while !eof() routine and passing this data from the source
tables (order header, order detail) through a filter and recording the results into three tables, customer, order header, order detail.

>
>Are there many indexes on the table you are importing to?

Yes, there are several indexes in all the three files.

>You may have temp files that are filling up the disk, as soon as you acknowledge the error VFP erases the temp files.

I figured this could be it, but how can I prevent this type of error from happening?. It takes for the whole routine about 7-8 hrs to get completed, I have an error trapping routine, but at one point I have to cancel the process, because doesn't find even room to record the error in my error log.

I there a way to deal with the temp files and empty them somehow?


Thanks Jim,

GIl