Click here to Skip to main content
15,740,731 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
How can I import and export excel data to sql2000 using 2008?
Updated 29-Nov-10 7:52am
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.

See here[^].
Share this answer
See This i already answered how to export Data to excel
excel sheet[^]
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900