Any quicker way to write data from DataTable to Excel?

M

musa.biralo

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!
 
P

Patrick Molloy

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

musa.biralo

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
 
P

Patrick Molloy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easy way to extract data and put into Excel? 1
Spreadsheet cleanup help 3
Merging row data in Column A has duplicate. 1
A DataTable-bound DataGridView throws a low-level Exception whencolumns are sorted, removed and re-a 1
transfer data from Dictionary to DataTable 2
Neat code for pasting filtered data to a separate worksheet 10
In VBA, check if file is corrupt or not Excel 5
convert long list into shorter list 4

Top