The most efficient way to export large amount of data to excel

Question

If you had to get large amount data(nearly 230.000 rows) from database(I use oracle) to an excel file with asp.net, how would you do it? I need some advice about this issue.

Answer 1

You should consider using csv(Comma Separated Value) file format. It is very lightweight and supported by excel:

http://creativyst.com/Doc/Articles/CSV/CSV01.htm