|
Re: The best elegant solution to override 65k rows limit in a sheet
You should still be able to do most of any math, aggregations that you need
on the DB and pull back much less data. How many times do you need to look
at a million rows?
--
HTH
Bob Phillips
"taz" <taz.1rr73i_1120662593.3576@excelforum-nospam.com> wrote in message
news:taz.1rr73i_1120662593.3576@excelforum-nospam.com...
>
> Let's assume that we must use EXCEL as a reporting engine / designer
> that pull the data from a dbms (like SQL & Oracle) but has to eat big
> chunks of data at a time (more than 65k rows obviously).
>
> I insist on excel because many people know that tool and do not depend
> on IT department for many aspects
>
> Let's think about excel like a heart that pumps in/out the data after
> the right transformations/calculations
>
>
> --
> taz
> ------------------------------------------------------------------------
> taz's Profile:
http://www.excelforum.com/member.php...o&userid=24948
> View this thread: http://www.excelforum.com/showthread...hreadid=384823
>
|