CSV output exceeding 65356 rows

[Santy]

Hi,
I have number of reports that output data to CSV. The number of records exceeds 65536 & excel gives an error "File not loaded completely".
any help appreciated. waiting for prompt reply.
currently working on E811
Thanx
Santy

 

[Sebastian Sajaroff]

Hi,

That's an Excel limitation : it can't handle more than
65536 rows.
You should either work with some other spreadsheet or
with some other tool (may be exporting data to text and then
into MS Access or MSDE which don't have the 65536 row
limit).

 

[eydeak]

The 65,000 record limit is a limitation of Excel and I've never heard of
any way around it. You can load the CSV into something else (like
Access) instead.



Ellen Deak

Senior Systems Developer

Cooper Standard Automotive

JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
Citrix Clients

 

[GSI Inc.]

Is the purpose of the UBE to output to CSV to be used in execl? If so that is the max number of rows allowed in excel. Tell us a little more detail of how you want to use the CSV output. Thanks - Angelis

 

[MattNorman]

I think that opening the report from the work with submitted jobs screen will, at first, transfer the file from the Application server to the citrix server you are on (if citrix) or into your temporary internet files (if you are on web).

Then Excel opens the file from that location, since the .csv file extension is associated with Excel.

Therefore, if you immediately close Excel without saving, or disassociate .csv from Excel, you will be able to import the .csv file into Access or similar in is untruncated form.

Hope this helps.