More than 65,000 rows

[Hiran de Silva]

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.

 

[Nigel]

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

 

[Jamie Collins]

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/[email protected]&rnum=8

Jamie.

--