does Excel have memory limit of data Array?
"miao jie" wrote ...
I use ADO to read the
data in table into data array in Memory.
Is it useful to have 100K+ elements in memory? Why not operate on the
table using SQL e.g. use a WHERE clause to return only the rows you
require. Post more details of what you are using the array for, you
may be taking the wrong approach.
Jamie.
--
|