>I am looking for docuemntation which would allow me to access and modify data from VFP6 into SQL Server. If any body can help. Thanks.

Here might be a good starting point:

Integrating SQL Server with Visual FoxPro
Robert Green
Microsoft Corporation

http://www.msdn.microsoft.com/isapi/msdnlib2.idc?theURL=/library/techart/msdn_bko02.htm