import and export excel

Question

4.00/5 (1 vote)

See more:

How can I import and export excel data to sql2000 using vb.net 2008?

Posted 29-Nov-10 6:56am

Updated 29-Nov-10 7:52am

v2

Comments

Crushe 11-May-16 5:15am

One of the easiest ways is by using a VB.NET dll for excel.
See the following example of both importing and exporting DataTable to Excel in VB.NET.
FYI for exporting you can simply use SqlBulkCopy.WriteToServer method to write the DataTable to database.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2010-11-29T07:26:00

See here[^].

Posted 29-Nov-10 7:26am

nitin bhoyate · Answer 2 · 2010-11-29T18:25:00

See This i already answered how to export Data to excel
excel sheet[^]

Posted 29-Nov-10 18:25pm