WORD VBA

[Guest]

I am trying to create a WORD document about 40 thousand pages. I get the data
from a database (ORACLE) and write it into a Word Document. When the number
of pages passes some few hundreds it begins to eat up memory and CPU
resources of my machine. Is WORD application capable to handle this size
document? If so how can I create it? If word is not a good tool to do this,
what tool should I use?

 

[macropod]

Suggest you look under 'Limits for Word' in the Word help file. The number
of pages isn't limited, as such, but there are other issues you may have to
deal with. Even if you stay within Word's limits, 40,000 pages is a lot, and
you can't expect stellar performance - running molasses down a glacier is
more likely. I recommend you consider breaking the job up into many smaller
files.

Cheers

 

[Guest]

I thought what you suggest. I am looking for a more convenient way of doing
it. I may use Excel for instance, however presentation won't be same!
Thank you Macropod,
F.T

 

[Suzanne S. Barnhill]

I have no experience with either Oracle or Access, but I would imagine that
Access might be your best bet. As a database, it's designed to contain huge
amounts of data, and my understanding is that it is capable of creating very
attractive reports.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Ed]

You might want to check into the Oracle forums
(http://forums.oracle.com/forums/category.jspa?categoryID=18) and see what
the users there can tell you.

Ed