>Hello
>
>What's the fastest way to populate a foxpro table from SQL server using ADO? is creating recordset and loop throught it and populate the table is the most efficient way.
>
>I am using VFP6

Take a look at file #1454 and File #10002. See also mskb #Q262067.