help me! how to store data from excel using vb.net

[winmani]

hi buddies,

cud u explain, how to retrieve data from excel file and save into oracle database using vb.net.

[mady1380]

hi buddies,

cud u explain, how to retrieve data from excel file and save into oracle database using vb.net.

hi

check this code



Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here

'Create new Excel Object
Dim MyExcel As Excel.Application

MyExcel = New Excel.Application
MyExcel.DisplayAlerts = False
MyExcel.Workbooks.Open("C:\Inetpub\wwwroot\WebAppl ication1\Excel1.xls")
Label1.Text = MyExcel.ActiveWorkbook.ActiveSheet.Cells(1, 1).Value

'Insert data into particular cell of Excel Sheet
MyExcel.ActiveWorkbook.ActiveSheet.cells(2, 4) = "Example"

MyExcel.ActiveWorkbook.Save()
MyExcel.ActiveWorkbook.Close(False, "C:\Inetpub\wwwroot\WebApplication1\Excel1.xls ")
MyExcel.DisplayAlerts = False
MyExcel.Quit()


ReleaseComObject(MyExcel)
MyExcel = Nothing
GC.Collect(1)
GC.WaitForPendingFinalizers()
End Sub