stored procedure row output to access table -- sql server programming

gtr
11/13/2004 2:22:01 PM

Thanks Dandy.
This looks like the way i would do it in T-sql. Does something like this
work in vb? If so, how?

[quoted text, click to view]

gtr
11/13/2004 2:25:01 PM

Hugo,
Yes you are right, maybe this question should have been asked in a vb/access
newsgroup.
I think this just may work - select into from pass-through query.

Thanks for your help.

[quoted text, click to view]

Hugo Kornelis
11/13/2004 10:27:03 PM

[quoted text, click to view]

Hi gtr,

Should this question not be asked in an Access or VB newsgroup?

Anyway, here are the steps to do what you want in Access. I know almost
nothing about VB, but I think you can work out how to initiate theses
steps from VB code.

1. Create a pass-through query (named Query1 in my example) with this SQL
test:
exec sp_who '3'
(I used sp_who as example proc and '3' as example parameter).
2. Create a second query with the following SQL text:
SELECT Query1.* INTO Test
FROM Query1;
3. Execute the second query.

Best, Hugo
--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : stored procedure row output to access table