Daniel,
I get the idea. Thank you very much. That certaily helps. I will have to test this approach over 20,000 to 30,000 records to see how fast it works.

------------------------------------------------------
>Aristotle,
>
>You could try something like this:
>
>*-- create some test data
>CREATE CURSOR bidon (cTest C(10) )
>FOR i = 1 TO 100
> INSERT INTO bidon VALUES(PADL(i, 10, "0"))
>ENDFOR &&* i = 1 TO 100
>
>*-- connect to SQL Server
>nSql=SQLCONNECT(MyServer, User, Pw)
>
>*-- create SQL Server table
>?SQLEXEC(nSql, "CREATE TABLE TestTable (cTest char(10))" )
>
>*-- insert the VFP data into SQL Server
>SCAN
> SQLEXEC(nSql, "INSERT INTO TestTable VALUES(" + cTest + ")" )
>ENDSCAN
>
>Hope this helps,