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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.