>>I have the stored procedure complete and can run it in VFP by calling "do getpackagecontents"... i get back the result set I want.
>>
>>Now the question is... how do I call this SP from Excel? I have the data connection but I only have choices for command types of "table" and "SQL". Anyone able to lend me a hand?
>
>What are you using to connect to VFP data? Only VFP OLE DB provider allows to execute VFP stored procedures.

Yes... I'm trying to connect to VFP stored procedure. I'm using VFP OLE DB and I've been able to get it to execute the stored procedure. my problem is I only get back "True" as a result.

Thanks for your help!