How to take table dump

[Former Member]

I have a table TBTCO in quality having 2,90,000 records i want to download all but excel is allowing only 65,0000 records what way i can download remaing records could any one please suggest me.

[Former Member]

I have a table TBTCO in quality having 2,90,000 records i want to download all but excel is allowing only 65,0000 records what way i can download remaing records could any one please suggest me.

[Former Member]

Do you use SE16 to download the data? Choose "Local File" instead of Excel en you will be able to download the data.

Regards,

John.

[Former Member]

if the MS office is older version then it has a restriction on the number of records and so the issue. Try with Ms office 2007.

[Former Member]

Hi,

That is a limitation of the older versions of Microsoft Office. Go for a newer version of the same. Not sure if MS Office 2003

would help, but 2007 surely overcomes the limitation.

Regards,

Sagar

[Former Member]

Hi Venkat,

As you know MS-Excel-2003 and older versions have a limitation to hold only square of (256) i.e. 65536 records but now the higher version of MS-Excell i.e. 2007 can hold upto 1048576(square of 1024) records. So the solution in your case would be to install the new version.

OR Alternatively there is a work around but it needs to put in some efforts.

If you are not comfortable with the installation of new MS-Office components and still need the data in an excel format then what you can do is, you can take a download of this table in an 'unconverted' format by using the 'Download to local file' option available in the table browser and then open this file in 'EDIT-PLUS' (free trial version available on the Internet) and then copy the records in an excel file in different worksheets.

Edit Plus becoz it show the line number when you open a file in it, so it will be easier for you to copy 65536 records each time and paste it in Excel.

Try it out....

Cheerss.....Enjoy.

Regards,

Abhijit G. Borkar