Error retrieve data returned from Web Service

[Wing Chan]

Hello,

I am having a runtime error when automating the following process:

-Make a connection to a web service that returns a recordset of data (which
is a lot more than 80,000 rows and with lots of columns)
-Then insert all these records into an access table
-Refresh the pivot table in excel that is pointed to that access table.

The error I got is that when that the variable I declared from below
(arrTemp) cannot hold that many rows of records.
Does anyone have some insights I really appreciate it. Thanks in advance.

Set oSOAPClient = CreateObject("MSSOAP.SoapClient")
oSOAPClient.MSSoapInit "http://" + sServer +
"/WebService1/Service1.asmx?wsdl", "Service1", "Service1Soap"

Dim arrTemp()
arrTemp = oSOAPClient.spSlsCrossTab()

[Registered User]

On Fri, 7 Oct 2005 12:26:03 -0700, Wing Chan
<Wi******@discussions.microsoft.com> wrote:

Hello,

I am having a runtime error when automating the following process:

-Make a connection to a web service that returns a recordset of data (which
is a lot more than 80,000 rows and with lots of columns)
-Then insert all these records into an access table
-Refresh the pivot table in excel that is pointed to that access table.

The error I got is that when that the variable I declared from below
(arrTemp) cannot hold that many rows of records.
Does anyone have some insights I really appreciate it. Thanks in advance.
80,000 of anything is a relatively large number. The run-time array
error is a symptom that suggests something is wrong with the server
design. The client would be better served if paged data were
available. Each client could then set its desired page size when
consuming the data

public sometype[] spSlsCrossTab(int StartingRecord, int
RecordsToReturn);

regards
A.G.
Set oSOAPClient = CreateObject("MSSOAP.SoapClient")
oSOAPClient.MSSoapInit "http://" + sServer +
"/WebService1/Service1.asmx?wsdl", "Service1", "Service1Soap"

Dim arrTemp()
arrTemp = oSOAPClient.spSlsCrossTab()