Any quicker way to write data from DataTable to Excel?
 

Hello Group!

I have a DataTable as below and currently I am writing this to excel
by looping through each column and then each row. I am wondering if
there is a quicker way to dump all the data once or any time smart
method to save data writing process.

col1 col 2 col3
A B C
D E F

I am playing with VB.NET
Thanks a lot!

Any quicker way to write data from DataTable to Excel?
 

does the dataTable come from a recordset? if so, you could use the Excel
Range's CopyFromRecordset method

"musa.biralo" wrote in message
...
Hello Group!

I have a DataTable as below and currently I am writing this to excel
by looping through each column and then each row. I am wondering if
there is a quicker way to dump all the data once or any time smart
method to save data writing process.

col1 col 2 col3
A B C
D E F

I am playing with VB.NET
Thanks a lot!

Any quicker way to write data from DataTable to Excel?
 

Thank You Patrick.
The DataTable is created from DataSet.
Do you have any snippet or any web-link that I can follow?

Thanks for your time.

Musa.Biralo

On Jun 18, 10:55*am, "Patrick Molloy"
wrote:
does the dataTable come from a recordset? if so, you could use the Excel
Range's CopyFromRecordset method

"musa.biralo" wrote in message

...

Hello Group!

I have a DataTable as below and currently I am writing this to excel
by looping through each column and then each row. I am wondering if
there is a quicker way to dump all the data once or any time smart
method to save data writing process.

col1 *col 2 col3
A * * * B * * * *C
D * * * E * * * *F

I am playing with VB.NET
Thanks a lot!

Any quicker way to write data from DataTable to Excel?
 

alas no ... the last time i had to do this i iterated through the DataTable
(C#)
However, you probably already have the sql, so you could maybe use a
DataReader instead - I've found that to be quicker

"musa.biralo" wrote in message
...
Thank You Patrick.
The DataTable is created from DataSet.
Do you have any snippet or any web-link that I can follow?

Thanks for your time.

Musa.Biralo

On Jun 18, 10:55 am, "Patrick Molloy"
wrote:
does the dataTable come from a recordset? if so, you could use the Excel
Range's CopyFromRecordset method

"musa.biralo" wrote in message

...

Hello Group!

I have a DataTable as below and currently I am writing this to excel
by looping through each column and then each row. I am wondering if
there is a quicker way to dump all the data once or any time smart
method to save data writing process.

col1 col 2 col3
A B C
D E F

I am playing with VB.NET
Thanks a lot!