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