Hi,

You can either establish a connection to SQL server and update through VFP or you have more control using DTS. The latter will allow you to manipulate data so that SQL server can understand it. For example there are no empty date fields in SQL Server but VFP allows them. Importing this kind of data into SQL server will create an error.

- Val Matison


>Dear all,
>
>Can I using "INSERT" command to add the huge data into SQL Database? The structure of VFP table is same as SQL Database. I wouldn't like to use VFP upsize wizard. Thank you very mcuh ...
>
>Best Regards,
>
>Justy Chow