You could use the View designer to help you create your SQL Server connection and table view to perform your update.

>Cathi, thanks for your reply.
>
>The Web app will be updated from various different sites so it would be safer to assume there is no direct access to the web server.
>
>Is there any tool , process avaolable which will automate the 'Sending' of the data from the PC to the web server and then get something to 'Automatically' run the app on the server ?
>
>Regards,
>
>Gerard
>
>
>
>>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