Creating/problem with an Excel Object

I am programming in VB. i am creating an excel spreadsheet using an excel object.

I am using an oracle database as my datasource. I read in my data and create an Excel Object and start to build the Spreadsheet from my data.

When i create spreadsheets from smaller amounts of data, i have no problem. It creates the spreadsheet just fine. But when i use large amounts of data, i get an “out of memory” error.

Is there a size limitation on the excel spreadsheet object/excel/objectin memory?

Is there something memory wise i need to do when working with large amounts of data using an excel object?

Operating sys: 98
office verstion: 2000
VB version: 6.0