>HI All,
>
>AS USAUAL I'M A BIT STUCK SO AM TURNING TO YOU GUYS FOR SOME HELP.
>
>I'm using a view and need to import from an external file. The Import is no problem.
>
>My Issue is that before i import i need to clear out ALL the records in the table. I am trying to stick with views and not use the actual tables. Now i know that i cant use Zap on the view, and delete all followed by tableupdate(.t.) has two problems
>
>1. it takes a long time ( about 2 mnutes for 6.5K records )
>2. i still have to access the actual tables at some point and do a pack
>
>
>Can someonme please tell me what i should be doing ?
>
>Regards
>
>TIA
>
>Colin