Ryan,

You could do it in a two-step process depending on your version of SQL Server. If 2005 or later from the Stored Proc side:

DECLARE @foo XML;
SET @foo = (SELECT * FROM mytable FOR XML AUTO, TYPE)
RETURN @foo

SQLEXEC this from VFP and then use XMLtoCursor to consume it into a table to slice and dice. I don't have access to either VFP or SQL Server as I write this and YMMV,


>Dear all,
>
> is't possible to create a Store Proc To Export MS SQL Data In FoxPro DBF, if it's possible then how?
>
>Thanks,