How to Export Dataset to Excel Using Microsoft.Interop VB.Net & SQL Server

Hi Jack

This post is a continuation of the previous post 

How to Export Dataset to Excel Using XML VB.Net & SQL Server 

this time we will use Microsoft.Interop to export from the dataset to excel file.

How to Export Dataset to Excel Using XML VB.Net & SQL Server

Hi Jack

How to Export Dataset to Excel Using XML VB.Net & SQL Server

In this post we will note how of database dataset exported into microsoft excel.

we will be using xml, and then on the next we ae going to use Microsoft Office Interop so we can compare the performance of both.

Post #3 : Programming "How to import file excel into Datagridview in Visual Studio Using Visual Basic .Net"

Hi. Jack

Today we will try to import data from excel file "xls" or "xlsx" to datagridview, this script has been tested using visual studio 2010.

Q. Why do we have to import data from excel to a DataGridView ?

A. Sometimes many companies initially did all the needs of theirs data using excel, when they begin to migrate using application, it would be quite a hassle if you have to enter one by one manualy. Therefore, should we provide import function from excel to DataGridView to Database .

Okay let's start .