Z
zachi.fernaldes
Hi all,
I've faced with a problem:
I'm executing a script in excel vba which send parameters to SQL stored
procedure and import it's results to excel work sheet, as you can see
below:
ParArray = Array(Array("@Planet", adVarChar, 50, strSelectedPlanet), _
Array("@StartTime", adDate, 50, strStartTime), _
Array("@EndTime", adDate, 50, strEndTime))
Set rsTemp = ExecSP("USPS_sysLoginsInformation_RT", 3, ParArray)
' Copy the records into cell A1 on Sheet1.
Sheet1.Range("A1").CopyFromRecordset rsTemp
The Problem is that i receive the data without it's columns headings
names. How can i get the data with the fields names?
Thanks for your help.
I've faced with a problem:
I'm executing a script in excel vba which send parameters to SQL stored
procedure and import it's results to excel work sheet, as you can see
below:
ParArray = Array(Array("@Planet", adVarChar, 50, strSelectedPlanet), _
Array("@StartTime", adDate, 50, strStartTime), _
Array("@EndTime", adDate, 50, strEndTime))
Set rsTemp = ExecSP("USPS_sysLoginsInformation_RT", 3, ParArray)
' Copy the records into cell A1 on Sheet1.
Sheet1.Range("A1").CopyFromRecordset rsTemp
The Problem is that i receive the data without it's columns headings
names. How can i get the data with the fields names?
Thanks for your help.