topic Re: Extract data into Excel in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435427#M1739648 <HTML><HEAD></HEAD><BODY><P>Since the Excel limit (2010) is just above 1 million rows, it's never going to work, is it. No matter how hard you try, you can't fit a pint into a half-pint mug.</P><P></P><P>What do your users want to do with all this data? Maybe there's some other way of achieving it. </P></BODY></HTML> Mon, 27 May 2013 07:31:11 GMT matt 2013-05-27T07:31:11Z Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435426#M1739647 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>We have a requirement, where we need to extract more than two million records of data from tables(R/3) into excel.</P><P></P><P>Issue is with the number of rows limit.</P><P></P><P></P><P>Any idea how to transfer this data into excel.</P><P></P><P></P><P></P><P>Rgds</P><P>sumanth.</P></BODY></HTML> Mon, 27 May 2013 06:35:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435426#M1739647 Former Member 2013-05-27T06:35:58Z Re: Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435427#M1739648 <HTML><HEAD></HEAD><BODY><P>Since the Excel limit (2010) is just above 1 million rows, it's never going to work, is it. No matter how hard you try, you can't fit a pint into a half-pint mug.</P><P></P><P>What do your users want to do with all this data? Maybe there's some other way of achieving it. </P></BODY></HTML> Mon, 27 May 2013 07:31:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435427#M1739648 matt 2013-05-27T07:31:11Z Re: Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435428#M1739649 <HTML><HEAD></HEAD><BODY><P>No way in one sheet in Excel, currently last versions of Excel, not in compatibility mode, is 2^20 = 1048576 rows. (Or look for some future new version later) You could try another format like xml or export to another database, or split in shorter extracts to multiple tab in Excel.</P><P></P><P>But what is the actual requirement of final users, have you implemented a Datawarehouse like BW in your system landscape ?</P><P></P><P>Regards,</P><P>Raymond</P></BODY></HTML> Mon, 27 May 2013 08:02:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435428#M1739649 RaymondGiuseppi 2013-05-27T08:02:51Z Re: Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435429#M1739650 <HTML><HEAD></HEAD><BODY><P>there is no way to upload such big data because there are 104800 rows in excel sheet.</P></BODY></HTML> Mon, 27 May 2013 09:37:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435429#M1739650 former_member547570 2013-05-27T09:37:58Z Re: Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435430#M1739651 <HTML><HEAD></HEAD><BODY><P>Download your this large amount of data in Multiple Sheets in One Excel File using OLE ABAP Code&nbsp; or Download your data into Notepad , so their is no restriction of lines in&nbsp; Notepad&nbsp; .</P><P></P><P>Regard's</P><P>Smruti </P></BODY></HTML> Mon, 27 May 2013 10:19:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435430#M1739651 Former Member 2013-05-27T10:19:21Z Re: Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435431#M1739652 <HTML><HEAD></HEAD><BODY><P>Divide the extract in different excels like extract 1, extract 2 and so on or extract the data in notepad with .txt extension.</P></BODY></HTML> Tue, 28 May 2013 06:59:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435431#M1739652 Former Member 2013-05-28T06:59:30Z Re: Extract data into Excel https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435432#M1739653 <HTML><HEAD></HEAD><BODY><P>Hi Saket,</P><P></P><P>You can download huge data by dividing the number of records and downloading into the different excel sheets say data1, data2 and so on.</P></BODY></HTML> Tue, 28 May 2013 07:32:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extract-data-into-excel/m-p/9435432#M1739653 Former Member 2013-05-28T07:32:58Z