There is one other choice. See my FAQ page. Scroll down to the section headed "Ledger."

When is Adagio going to export files to Excel that are compatibile with datasets over 65000 rows?

Client does not want to use GridView as it is too slow for their dataset (running locally on a brand new RDP server so hardware is not the issue). 800,000+ ledger records. 1.5 minutes to run a querry on ledger transactions.

What are they going to do with 800,000+ records? 10,000 records / second doesn't seem too bad to me.

If this is for their auditors, and their auditors are using Caseware, then no export is required.

As a follow on:

If you export the transactions to Excel using File | Export | Transactions you need to change the default file extension from .XLS to .XLSX if you want to export more than 65,535 rows. Works fine. GridView ExcelDirect works fine too.

Exporting from Crystal Reports will not change. It is not designed for this type of operation.