Download to Ex-Cel file which contains data more than 65533 approximately

[Former Member]

I want to download the SAP report which contains more than 180000 data appr. into excel file but ex-cel can accomodate only 65533 in one worksheet ( i.e., tab). Kindly tell me how to download the output into ex-cel file.

Thanks in advance

Renuka

[Former Member]

You can also download this as .txt file and then open up and include 65533 lines in a single page and have multiple pages on the worksheet.

[Former Member]

Thanks for the reply.

Regards

Renukaprasad.

[Former Member]

Hi,

Sorry, I thought that your query related to the inability to download over X lines to excel

I have editted my response.

Steve B

[Former Member]

You can't handle more than 65000 line in Excel.

One way, is to donwload the file in a "csv" format and then open it with access...

Hope this helps,

Erwan.