This was a very simple fix, but not well documented.
Excel by default opens as XLS.
In order for the 65,000+ to work, it needs to be XLSX.
Here is how change EXCEL so by default it opens as XLSX.
1. Open Excel (you should get Book1 [Compatibility Mode] by default)
2. Save-As (F12) and save it as Book1.xlsx (the 2007 format) in the following location:
C:\Program Files\Microsoft Office\Office12\XLSTART
3. Restart Excel

Paul


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of MARK GOLDEN
Sent: Thursday, April 17, 2014 3:22 PM
To: Midrange Systems Technical Discussion
Subject: Re: Excel - IBM I Access Data Transfer error at 64, 000 rows - CWBTF0012

Hi,

This is a commercial option.

iEXL: AS400/Power based to create actual Excel spreadsheets.

If you have an interest it can be found at WWW.iEXLSOFTWARE.COM

Mark Golden 


________________________________
From: "rob@xxxxxxxxx" <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, 17 April 2014, 20:18
Subject: Re: Excel - IBM I Access Data Transfer error at 64, 000 rows - CWBTF0012


Another option?  Use the Scott Klement technique of writing directly to
Excel.  Bypassing CSV and file transfer.

Search also SQL2XLS.


Rob Berendt

This thread ...



Return to Archive home page | Return to MIDRANGE.COM home page