Excel Buffer Table

JAYESH

HI to all..

I am trying to export data in excel sheet.
I used Excel Buffer Table.

Can any one tell me if i have more then 70000 records.
Excel has limitation for the records.

so when i export data it automaticall shifted on to next sheet or is there any code i have to included ??

I request you to please share ur ideas..

Thank you..

nunomaia

Excel can store 65,536 rows. To use 70 000 rows has you have said well you must customize Excel Buffer. A faster way probably it's to use automation. Don't forget that Excel buffer uses temporary table that is stored in client memory and can have some performance degradation. A better alternative it's to use automation directly.

David_Singleton

JAYESH wrote:

HI to all..

I am trying to export data in excel sheet.
I used Excel Buffer Table.

Can any one tell me if i have more then 70000 records.
Excel has limitation for the records.

so when i export data it automaticall shifted on to next sheet or is there any code i have to included ??

I request you to please share ur ideas..

Thank you..

I guess an upgrade to Office 2007 would be the simplest solution, then you have 1,050,000 rows.