|
Re: The best elegant solution to override 65k rows limit in a sheet
Split the records into multiple files, write an app in C++ that does the
dirty work considering the .xls-file folder as one huge file.
And if one .xls-file is full, just let the app create a new one.
U can also write a module in VBA (Access maybe) but that's not so fast.
"taz" <taz.1rqvuc_1120647907.602@excelforum-nospam.com> schreef in bericht
news:taz.1rqvuc_1120647907.602@excelforum-nospam.com...
>
> I'd like your opinion/solution to break the limit of 65k lines in a XLS
> sheet.
>
> I.E. let's say we can have 4 millions records to treat and have excel
> read virtually every record from this db. Is there an elegant and
> transparent solution for the users of my company?
>
>
> --
> taz
> ------------------------------------------------------------------------
> taz's Profile:
> http://www.excelforum.com/member.php...o&userid=24948
> View this thread: http://www.excelforum.com/showthread...hreadid=384823
>
|