>>I just tried this only to find VFP does not support this (syntax error). Better
>>get my crayons out again and find a different way.
>
>You should be able to do it using SQL Passthru. How are you doing it now, Remote Views?
Yep! I've got two and a half million rows to add in 340 updates (daily). I've tried many different ways - I want to update up to 100k rows in one shot. I think I've got an answer now - APPEND FROM into a remote view - not nice I know, but fast.