Colin

I don't quite understand. You can't import into a view. A view is a "view" into 1 or more related tables that already exist. If your view is already populated, and your new import is to the same underlying tables, then you REQUERY() your view, to get the freshest data therein. Does this help?

Terry

>>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