> hi all
>
> I have a table in foxpro(.dbf), then I want to copy the whole data from table .dbf to SQL server table. how to do that??
>
> Thanks a lot,
>
> Michael


You can create table from your SQL Server which the same structure as your VFP tables and send those data through SPT using Insert to add records or SQL Update if you have changes or modification to you data.

ODBC or SQL StringConnection will do the job to communicate two databases (VFP to SQL).

Just read and study Pete's article.

http://www.foxite.com/faq/default.aspx?id=8

Best Regards,

CriZ (,")

"Everyone is entitled to their own opinion, but not their own facts."