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!

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

"musa.biralo" <(E-Mail Removed)> wrote in message
news:adecf8db-33ef-4e18-92a3-(E-Mail Removed)...
> 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!

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" <patrick_mol...@hotmail.com>
wrote:
> does the dataTable come from a recordset? if so, you could use the Excel
> Range's CopyFromRecordset method
>
> "musa.biralo" <musa.bir...@gmail.com> wrote in message
>
> news:adecf8db-33ef-4e18-92a3-(E-Mail Removed)...
>
> > 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!
>
>

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" <(E-Mail Removed)> wrote in message
news:af9855fc-049c-44d6-b4d3-(E-Mail Removed)...
> 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" <patrick_mol...@hotmail.com>
> wrote:
>> does the dataTable come from a recordset? if so, you could use the Excel
>> Range's CopyFromRecordset method
>>
>> "musa.biralo" <musa.bir...@gmail.com> wrote in message
>>
>> news:adecf8db-33ef-4e18-92a3-(E-Mail Removed)...
>>
>> > 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!
>>
>>
>