Gerard,

Does your VFP application workstations have access to the web server? If so, then you can write an app that does the whole update from a workstation. To perform the update you can use the OLE DB provider that ships with VFP7 or the ODBC driver that ships with VFP6 or earlier. The VFP help files show how to use these drivers to connect to your backend and perform the updates.

If your workstations don't have access, then you will need to export your data out of your VFP application and then transfer the data to the server. Then you can run another program (VFP app) that performs the update using the OLE DB provider or the ODBC provider as explained above.

>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