Out of Heap Space

I recently had an interesting error and I was wondering if anyone else has seen this before. I have 2 queries that each run perfectly. In MS query I unioned them together and it ran great. Then when I exited MS Query to have the data returned to XL after a minute or two of exectution I get an error that the application is out of heap space. I have overflowed the stack more times than I can count but I have never had an issue with heap space. Anyone care to enlighten me...

Jim

It doesn't help you, but this explains the 'Heap' space in various versions of Excel.

I've not seen the error you are encountering, anyone?

I have that web site bookmarked on all of my computers. It is a great reference. The part that surprised me was that I would not have expected a query to use up heap space. I did receive a direct e-mail through your site from someone indicating that MS Query does not like unions, but I do unions fairly regularly without issue.

I resolved the issue by not unioning the queries and just running them seperately, so it is more of a curiosity than a real problem.

I resolved the issue for good... It was an issue with the DB2 database and not XL. I will get the admins to up the Heap space available on the DB2 application...