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