[sanjay5219]

Hi All,

I have to create a VB.Net Module where user will upload excel file in one table and excel file is having multiple sheet and all have to insert in one table.

[CharlieMay]

This might be a good first step

[EterS]

Do you mean to export Exel to a DataTable?

If so, I hope my code can help you.

			Dim workbook As New Workbook()

			workbook.LoadFromFile("C:\Simple.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			Dim dataTable As DataTable = sheet.ExportDataTable()
			Me.dataGridView1.DataSource = dataTable

I use a VB .NET Excel Library