download file from web service to be used for pivot
 

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