Reg : data download

[Former Member]

Hi all,

i have one report which consists of aroud 1 lakh records.

when i try to download those revords in to excel sheet its going for dump.

My questions is :

1. what is the maximum no of entries that we can download from sap to Excel.

2. what is the maximum no of entries that we can download from sap to HTML.

Regs,

Narayana

[Former Member]

Hi all,

i have one report which consists of aroud 1 lakh records.

when i try to download those revords in to excel sheet its going for dump.

My questions is :

1. what is the maximum no of entries that we can download from sap to Excel.

2. what is the maximum no of entries that we can download from sap to HTML.

Regs,

Narayana

[Former Member]

I think excel can handle only approx 65536 entries.

[Former Member]

There is a limit to download to excel , it is 65536, and excel cant handle more than that.

I belive if you use GUI_DOWNLOAD with file type "DAT", then ABAP should download the data to the file. and if you name it as ".xls" file in the file name you can open it in excel.

but if the records are more than what excel can handle, then it may not open,

and for html, i think there is no limit.

Also check your short dump message, if it says the dump is due to time limits!!

Regards

Usman

[Former Member]

Hi,

total no of records in excel sheet is 65536

if you have more no of records you need to split it into two excell sheets

regards,

Siva chalasani.

[Former Member]

Hi,

Better try to download d data to .txt files.....i think it has more limits than others.

thanks.