Can't see stored procedures in 'select data source' windows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tskogstrom - 27 Jun 2007 12:24 GMT

hi,
I tried to get data from a sql database where the data is in stored
procedures. I couldn't find the stored procedures in the "Select data
source" window, neither in Word or through Excel.

Should it be visible, or is there any other suggestion with VBA to get
the data? (I will probably make vba code anyway, because I want to
update the data on the file open event)

Kind reagrds
TSkogstrom

Reply to this Message

Maurice - 27 Jun 2007 20:02 GMT

using Stored Procedures within office you have to refer to the as queries. If
coding through VBA you can reference the ADOX library and use the Command
object which you can reference StoredProcedures.

hth

Signature

Maurice Ausum

> hi,
> I tried to get data from a sql database where the data is in stored
[quoted text clipped - 7 lines]
> Kind reagrds
> TSkogstrom

Reply to this Message