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!