sql server stored procedure data to access

leec
#1

sql server stored procedure data to access

Oct 15 '10, 02:09 PM

I need to populate an access table with the results from a SELECT stored procedure in SQL Server.

1. Is this possible?
2. If it is possible, can it all be part of the modified Stored Procedure?
3. What do I need to call to make this happen?

Last edited by NeoPa; Oct 15 '10, 03:02 PM. Reason: Reformatted as it was laid out in one paragraph - including all the questions.
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Oct 18 '10, 05:00 PM

1. Yes it's possible...

2. I don't know what you mean by "modified Stored Procedure"

3. Depends on which one is the push and which one is the pull...

Good Luck!!!

~~ CK
Comment

Comment