GetSqlData¶
Summary¶
Executes a Stored Procedure with a given parameter string and returns the data as a two-dimensional array.
If and error occurs, it will be returned in thr array.
The Procedure also needs to be authorised. Please have a look at the CSQLReflex function for more details.
Example¶
ds = Range("SERVER_NAME").Value
sp = Range("SP").Value
myParams = Range("PARAMS").Value
Range("A5:H103").Clear
Dim grid
With Application.COMAddIns("Calumo.ExcelClient").Object
grid = .GetSqlData(ds, sp, myParams)
End With
Range("A5:H103").Value = grid