Hi,

>so how to covert my existing dbf data with logical and memo field and data into MS SQL Server ?????

When you access SQL server from VFP, bit fields are automatically converted to logical fields. To convert DBF files to SQL server, you can use the upsizing wizard that comes with VFP. If you are using SQL Server 2005, you might want to check out the beta of service pack 2. Sedna contains an updated upsizing wizard (http://www.microsoft.com/downloads/details.aspx?familyid=05a0e7c9-43c1-417f-8810-ae7d7c66bac8&displaylang=en)