Hi,

There is table in SQL which consists of huge data around  2 million.When I am trying to export data to excel using recordListToExport(download),it is throwing an server error .Is there an efficient way to export huge data into excel or csv or even text file.

Thanks,
Prashanth  

Hi,
I just took a look at office support and I noticed that excel has a limit of 1,048,576 rows. so if you need to export almost 2 milion rows excel is not an option for you.

why do you need to have such a file?

Best regards

Carlos Rocha

Carlos Rocha wrote:
 
 Hi,
Is it possible to export huge table data into text file? If so,is there any inbuilt extension to do it?

Thanks,
Prashanth

In the Forge do a search for CSV and you'll find a few components that should work.