LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Loading/sorting array of Longs ( 65K rows)

I need to work with a couple of CSV files that have at least 350,000 rows --
too many to bring into Excel 2003. I can easily enough parse the columns into
an array, but I need to change the sorting so that I can then find a given
value in the array/table. If I do this with a simple row-by-row comparison,
it will take far too long. I found code that sorts long lists very
fast(http://www.devx.com/vb2themax/Tip/19470), but it is designed to work on
a single value per row. I can't easily figure out how to adapt it to my needs
so that it will sort a two- or three-column table. Can anyone help?

This is an enhancement to a large Excel macro. Changing entirely over to
Access is not an option. However, it's possible that enough of the users will
have Access on their machines that I could call Access from Excel VBA. I'm
checking into that now.
--
Gregg Roberts
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading data into an array QuietMan Excel Programming 1 April 26th 07 07:48 AM
Loading array into list box r wilcox Excel Programming 5 June 20th 05 11:14 PM
Count rows in text file by loading into array L Mehl Excel Programming 5 September 11th 04 07:15 AM
Loading Excel Array from VB Array Faster ExcelMonkey[_3_] Excel Programming 3 January 22nd 04 02:49 AM
Loading 3 Dimensional Array Alan Beban[_3_] Excel Programming 0 August 31st 03 03:00 AM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"