Hi.
I have been asked to update a web server files (using SQL Server) from a VFP desktop application. The field names are different but refer to the same data more or less.

I'm wondering waht is the best way to do this. My thoughts are as folows:

1. On Desktop, write an APP to export required fields into some Table
2. Email this to the server
3. On the Server, write another app to impirt the data into the Sql Server database

My qeries are:
1. Is there a way of automating this whole process
2. How easy is it to update a SQL database

Any help is appreciated.

regards,

Gerard