SQL Temp Table & Recordset

Hi new user here. But don't hold that against me.

I need a little help. I am using VB5 attaching to SQL Server 6.5, I have created a stored procedure which outputs to a temp table. what I want to do is....

Execute the stored procedure from within my vb code but before the temp table is dropped populate a recordset so that i can use the information returned by the Stored Proc.

Any Help would be greatly appreciated.

Thanks
Inferno!

Do you need to create a temporary table at all?

Why don't you just fire off a stored procedure to return a record set?

I think thats what i am going to do now.

I spotted that method on one of the other posts, haven't had chance to implement it yet though.

Thanks for the reply.