Extract data into Excel

[Former Member]

Hi Friends,

We have a requirement, where we need to extract more than two million records of data from tables(R/3) into excel.

Issue is with the number of rows limit.

Any idea how to transfer this data into excel.

Rgds

sumanth.

[matt]

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.

What do your users want to do with all this data? Maybe there's some other way of achieving it.

[RaymondGiuseppi]

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.

But what is the actual requirement of final users, have you implemented a Datawarehouse like BW in your system landscape ?

Regards,

Raymond

[former_member547570]

there is no way to upload such big data because there are 104800 rows in excel sheet.

[Former Member]

Download your this large amount of data in Multiple Sheets in One Excel File using OLE ABAP Code  or Download your data into Notepad , so their is no restriction of lines in  Notepad  .

Regard's

Smruti

[Former Member]

Divide the extract in different excels like extract 1, extract 2 and so on or extract the data in notepad with .txt extension.

[Former Member]

Hi Saket,

You can download huge data by dividing the number of records and downloading into the different excel sheets say data1, data2 and so on.