The issue is some tables reside on MS SQL, and some are local dbf.
The old code (all dbfs) used the "APPEND FROM" command.
That does't work with MS SQL

I currently have something like the following
SQLEXEC(lnHandle, INSERT into sqlTarget Values (m1,m2))
wraped in a loop procssing for each record in the local dbf.

Can I use a single command to bring in or "append" all the recs in a dbf into the MS SQL table.
Any brief illustration would be great.
Thanks