External Web Query

I have a web query that i go out to a URL and refresh the data weekly, but on one of my worksheets I keep getting a ‘Not enough memory’ error. There are only 25000 records and I have 256 mb of ram and a 2Gb pagefile. What is causing this error?