Wscript and stored procedure

R

Ralf Meuser

Hi there


I start understanding using the select statement to fillup my Excel sheet.

I do some thing like this:

..
Set objXL = WScript.CreateObject ("Excel.Application")
..
Set objWb2 = objXL.ActiveWorkBook.WorkSheets(1)
..
Dim cnn,rs,sql
Set cnn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
cnn.Open "Provider=SQLOLEDB; Data Source=serveur3; Initial Catalog=my_db;
User ID=xxx;Password=yyy"
rs.Open "SELECT a,b,SUM(c) AS c1 From MYTABLE Where a=10 & " Group BY
a,b",cnn,3,3,&H0001
Do While Not rs.EOF
objWb2.Cells(i, 1) = rs("a")
objWb2.Cells(i, 2) = rs("b")
objWb2.Cells(i, 3) = rs("c1")
rs.MoveNext
i = i + 1
Loop


Now I would like to know if there is some like this for stored prodedures?


Thanks in dfavance for your help.

Best regards

Ralf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top