Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |