Thanks for the code Dorin. I'll give it a try.

Since I know the data types and structures match, I thoguht there should be some way to move the VFP data into variables and pass them to SQL one row at a time. That's a bit tedious for adding 300 rows even though the process runs once a month. It's less than a dozen lines of code including error handling if you use a a remote view. Perhaps I should leave it that way...