>I'm importing 700,000 records from a FPW table into a VFP table. I have 1.5 GB available in my C: drive and 1.5 GB available in my e: drive (temp). I get the error message 'Not enough disk space' after a while that the routine has been running. I know is the cache doing something that I'm not aware of. But, what is it? The routine that I'm using to import is based on DO CASEs and IF statements. Am I forgetting to clear something or what should I do to avoid this error?
>
>Thanks in advance,
>
Gil,

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

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

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