There are several ways to do this. One is to create a remote view for each table and just append from your VFP tables into the remote views. If you do this, you may want to temporarily set the SQL Server database to Truncate Log on Checkpoint so that you don't overrun the transaction log.
You could also use SQL Server's BCP features. This will allow you to import ASCII files into SQL Server. This would be a much faster method, but it doesn't work with memo fields.
With either of these methods you would have to create the table definitions, etc. yourself or use the Upsizing wizard to create your database then move the data over using another method.
>Is there any way to upsize tables to SQl Server with out using wizard . Is some there in SQl Server on in VFP. Please guide me.
>Thanks.