transfer data from excel file to sql server programatically

[amit__8]

how to transfer data from excel file to sql server's tables in asp.net programatically i can't use wizard can any body will help me regarding the same thanks in advance

[chinnasrihari]

Hi, It is big procee Let give you hint Use the OleDbProvider and open the file and file in to data set and update to database ExcelConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="Excel 8.0;HDR=YES";Data Source = " & ExcelFilePath strSQL = "select Col1,Col2 from [Sheet1$]" SomeDataAdapter = New OleDbDataAdapter(strSQL, ExcelConnectionString ) have SomeDataSet declared daCollateral.Fill(SomeDataSet, ) :)try this Chinna Srihari Tech Lead, Capgemini

[amit__8]

thanks for the help, that i did but it shows more than 4000 records while my excel file contains only 500 and the problem is that how i will transfer the same into sql tables