Data transfer from excel file to sel server's table
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
how to transfer data from excel file to sql server's tables in asp.net programatically i can't use enterprise manager
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 if not i can help you Chinna Srihari Tech Lead, Capgemini