I read your conversation, and I am trying to do something similar:

Take FoxPro tables and update them to SQL server on a regular basis.

I've been able to do everything but to update the view in FoxPro back to SQL server programatically. It works fine if done visually, and I can even create a connection and a view programtically, I just can't get it to update.

Any thoughts?

Thanks,
Jeremy Stephens