I got the solution myself


>Hi Everybody,
>
>I use the following commands in VC++ to insert a number of records to a VFP table in a database:
>

>For (int i = 0; i <= reccount; i++){
>   cmd->CommandText =  "INSERT INTO MyTable (field1, field2) " +
>                       " Values(Value1[i], Value2[i]) ";
>   cmd->Execute(&vNull,&vNull,adCmdUnknown);
>}
>

>However it is fairly slow. Does anybody know any better way?
>
>Thank you,
>Ali