If you have VFP 9, use the SQL Server Upsizing Wizard at http://vfpx.codeplex.com/.

>I have an application written in VFP 6.0 that is being rewritten in C# with SQL Server backend.
>
>I will need to migrate the VFP data to the SQL Server tables. I haven't written any VFP code in ~10 years so would like to inquire as to the best mechanisms to migrate the data.
>
>I am figuring the most straightforward way will be some VFP prgs with custom code iterating the VFP tables. If so, can anyone provide the basic commands and syntax to use?
>
>Thanks,
>Bill