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

RE: Can't see stored procedures in 'select data source' windows by Maurice

Maurice
Wed Jun 27 14:02:01 CDT 2007

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
--
Maurice Ausum


"tskogstrom" wrote:

> 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
>
>