Use the upsizing wizard from VFPX to get the data into SQL Server.
http://vfpx.codeplex.com/If you have little experience with SQL Server, go with remote views.
>Hi All:
>
>I have very little experience working with SQL Server databases, but now my client has asked me to copy a bunch of VFP tables to SQL server as part of a program I wrote that he runs every day.
>
>I have gotten as far as installing SQL Server Express on my local machine, as well as importing the database structure to the SQL Server.
>
>I wonder is you can point me to some resources that will help me in this quest, as well as answer some questions like should I use views or SPT?
>
>I appreciate any help.
>
>Thanks,
>
>Yossi
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer