You can use SPT.

lnConn = SQLSTRINGCONNECT(...)
lnResult = SQLEXEC(lnConn, [EXEC MySproc], "clsSprocResult")
IF lnResult < 1
  * ODBC error, use AERROR() to pull detailed info
ENDIF

>Hi All:
> How can I export the result of a query into a vfp table from sql sp?
>Thaks for all the help!!!
>MA