Glenn, I can appreciate your position of being new in this arena.
I'd just like to offer a side thought to how this may be done outside of your application.
Since you have SQL Server involved you might consider creating DTS (Data Transformation Services) packages that will compare the data in the two databases (Fox and SQL) and move only new, updated or deleted data into the SQL dB. The DTS packages can be called from your application using the SQL-DMO (Distributed Mangement Objects). This SQL-DMO is the API used by Enterprise Manager in SQL Server 2000.
One good resource on using SQL DTS from within VB.NET is
http://www.vbdotnetheaven.com/Code/Jun2003/2070.aspA good overview of applying this method to your problem is found at
http://uk.builder.com/architecture/db/0,39026552,20274922,00.htm
THANKS
Joe Salvatore, Programmer/Analyst - The Stellar Group