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.EventArg s) Handles MyBase.Load
'Put user code to initialize the page here

'Create new Excel Object
Dim MyExcel As Excel.Applicati on

MyExcel = New Excel.Applicati on
MyExcel.Display Alerts = False
MyExcel.Workboo ks.Open("C:\Ine tpub\wwwroot\We bApplication1\E xcel1.xls")
Label1.Text = MyExcel.ActiveW orkbook.ActiveS heet.Cells(1, 1).Value

'Insert data into particular cell of Excel Sheet
MyExcel.ActiveW orkbook.ActiveS heet.cells(2, 4) = "Example"

MyExcel.ActiveW orkbook.Save()
MyExcel.ActiveW orkbook.Close(F alse, "C:\Inetpub\www root\WebApplica tion1\Excel1.xl s")
MyExcel.Display Alerts = False
MyExcel.Quit()


ReleaseComObjec t(MyExcel)
MyExcel = Nothing
GC.Collect(1)
GC.WaitForPendi ngFinalizers()
End Sub