More than 65,000 rows
 

I have an application that runs nicely on a worksheet (a set of
row-by-row-compare operations with several sorts). I may need to upscale it
to an environment which might go beyond 65k rows - I'm researching the
available choices.

eg. Spreading over multiple sheets, eg. continuation on sheet 2, is too
messy with sorts etc.
Access app is one choice.

I know this is an Excel ng - so asking for ideas that involve other
technological approaches maybe unusual in an Excel group, but some of you
may have had this kind of scenario before.

Thanks for any ideas, anything.

Hiran



PS: one of the benefits of the existing Excel VBA solution is the visual
feedback of the 'work being done'. Any ideas that preserve the 'row-by-row'
visual will be good. but I'd like to hear of others too.

More than 65,000 rows
 

Use Access - and link to an MDB database from within Excel. You do not need
Access to be running on the target machine, but will need it to create the
MDB.

Cheers
Nigel

"Hiran de Silva" wrote in message
...
I have an application that runs nicely on a worksheet (a set of
row-by-row-compare operations with several sorts). I may need to upscale
it
to an environment which might go beyond 65k rows - I'm researching the
available choices.

eg. Spreading over multiple sheets, eg. continuation on sheet 2, is too
messy with sorts etc.
Access app is one choice.

I know this is an Excel ng - so asking for ideas that involve other
technological approaches maybe unusual in an Excel group, but some of you
may have had this kind of scenario before.

Thanks for any ideas, anything.

Hiran



PS: one of the benefits of the existing Excel VBA solution is the visual
feedback of the 'work being done'. Any ideas that preserve the
'row-by-row'
visual will be good. but I'd like to hear of others too.

More than 65,000 rows
 

"Nigel" wrote ...

Use Access - and link to an MDB database from within Excel. You do not need
Access to be running on the target machine, but will need it to create the
MDB.

Incorrect, you don't need MS Access to create the mdb file either. See
previous posts e.g.

http://groups.google.com/groups?selm...gle.com&rnum=8

Jamie.

--