Thanks for the info;

I need to send data from VFP to duplicate tables in SQL Server via COM. There are a number of ways to do this and I am trying to decide on the best one.

I could create remote views on each SQL Server table, but that would mean creating and maintaining dozens of views. I could dynamically build INSERT statements based on the structure of the tables to be updated. I could also create a class that would receive VFP data as an ADO record set and map this across to the appropriate updateable SQL Server ADO record set.

Seeing examples of what others are doing helps with the decision making.