Exporting to Excel
I am stuck with a problem while exporting to Excel from asp.
I have to export abt 25K records to excel.I can successfully export 10k but the site where this application is hosted has server trasfer limit I am not able to export 25k+.
I tried writing to the xl file on the server and linking to the file on the browser.but I could write the records to the file but not able to display the link as page errors out.
I am thinking of dividing the files into parts so that all the files r written.but I am not sure how can I go abt this?
if any one of you have taken this approach can you pls guide me?
or if any of u guys out there has any other suggestions/ideas let me know.:(