Excel export - 65536 rows limitations 1

[johnhugh]

Hi, I'm exporting a Crystal report in Accpac 5.6.
Is there a way to get past the row limitation?
It seems that Accpac still does not know the xlsx format which does not have this limitation.

 

[ettienne]

No, export to CSV.

 

[johnhugh]

Good idea. And it works!
Does Accpac 6 still have the row limitations?

 

[Jay Converse]

If you're exporting that many records, you're using the wrong method. Get your data directly using an Excel data query.

 

[ettienne]

What tuba says, rethink your process. Exporting from Crystal is not ideal.

 

[ettienne]

Btw it is not an Accpac limitation. You are exporting from Crystal to an XLS file and the XLS file has a 65K row limit.

 

[mlnick]

The "not knowing xlsx" is at fault of Crystal Reports, not Accpac.

Newer versions of Crystal Reports are able to export to xlsx. I think it was added in Crystal Reports 2010 (Not 100% sure though).