Toad World® Forums

Data Compare - how to export more rows than ancient XLS limit?


I am working with Data Compare, and it is really useful, the only thing I currently miss is joins :slight_smile:

In order to do deeper analysis and also store some records of testing/analysis, I need to export output of Data compare into Excel. This functionality works also well, but seems that it didn’t realize that Excel file can contain already more than 65.536 rows.

Does someone have a workaround - how to export huge compare outputs into XLS, or create a separate table in DB out of it?

Any help is appreciated.

This limit has been addressed in our Toad DB2 v6.2 release.

That version should be released generally available on May 4th.