EDN Admin
Well-known member
Hi, i need to export a query result to excel.
I did it using a few methods but it seems that it is taking to long if loading large amount of data like 1000 rows.
I did looping a datatable and write the values to excel via excel object 11.0. - 20 secs for 1000 rows
exporting the data to CVS but i will have problems formatting the data.
using copyfromrecordset using adodb. But they want it to be done in .net
Are there any better and faster ways? Must be done programmatically using vb.net.
thanks
View the full article
I did it using a few methods but it seems that it is taking to long if loading large amount of data like 1000 rows.
I did looping a datatable and write the values to excel via excel object 11.0. - 20 secs for 1000 rows
exporting the data to CVS but i will have problems formatting the data.
using copyfromrecordset using adodb. But they want it to be done in .net
Are there any better and faster ways? Must be done programmatically using vb.net.
thanks
View the full article