urgent-transferrring data from excel to sqlserver using webforms

[tanya2001]

hi all
can somebody plzz tell me how to transfer data from excel 2003 to sql server 2000 using webforms.

I have a table in excel and i want to transfer the entire data into sqlserver table...how can i do it plzzz help me

[mzmishra]

This link will help you
http://forums.asp.net/p/1132513/1821793.aspx

[dip_developer]

hi all
can somebody plzz tell me how to transfer data from excel 2003 to sql server 2000 using webforms.

I have a table in excel and i want to transfer the entire data into sqlserver table...how can i do it plzzz help me

Fill a dataset with the excel records with the following code............now I think rest (inserting records into database from dataset)will be done easily

Dim conStr As String = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + fileName + "; Extended Properties=Excel 8.0;"
                    Dim sql As String = "select * from [Sheet1$]" '-------- "Sheet1" is the name of the excel sheet
                    MyConnection = New System.Data.OleDb.OleDbConnection(connectionstring)
                    MyConnection.Open()
                    MyAdapter = New System.Data.OleDb.OleDbDataAdapter(sql, MyConnection)
                    Dim myDataSet As DataSet = New System.Data.DataSet
                    MyAdapter.Fill(myDataSet)

[tanya2001]

Fill a dataset with the excel records with the following code............now I think rest (inserting records into database from dataset)will be done easily

Dim conStr As String = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + fileName + "; Extended Properties=Excel 8.0;"
                    Dim sql As String = "select * from [Sheet1$]" '-------- "Sheet1" is the name of the excel sheet
                    MyConnection = New System.Data.OleDb.OleDbConnection(connectionstring)
                    MyConnection.Open()
                    MyAdapter = New System.Data.OleDb.OleDbDataAdapter(sql, MyConnection)
                    Dim myDataSet As DataSet = New System.Data.DataSet
                    MyAdapter.Fill(myDataSet)

hi can u plz elaborate the code more plzz coz m all new 2 .net so i dunno much abt it...so can u plz...my excel sheet name is sheet1 and sql table name is table5

[Shashi Sadasivan]

hi,
the code given by dip_developer indicates pretty clearly that a dataset with the values of your excel file will be contained in it.
now its upto you to transfer them to the sql server, because you are the best who knows about the schema of your database and the schema of the excel file

[tanya2001]

hi,
the code given by dip_developer indicates pretty clearly that a dataset with the values of your excel file will be contained in it.
now its upto you to transfer them to the sql server, because you are the best who knows about the schema of your database and the schema of the excel file

i wanted to know tht the below code shows the connection string for excel
Dim conStr As String = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + fileName + "; Extended Properties=Excel 8.0;"

abd now here below agn asks for d same excel connection...where do v have 2 give the sql connection string
MyConnection = New System.Data.OleDb.OleDbConnection(connectionstring )

[dip_developer]

i wanted to know tht the below code shows the connection string for excel
Dim conStr As String = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + fileName + "; Extended Properties=Excel 8.0;"

abd now here below agn asks for d same excel connection...where do v have 2 give the sql connection string
MyConnection = New System.Data.OleDb.OleDbConnection(connectionstring )

extremely sorry friend.........the variable name connenctionstring would be conStr or vice versa....both are same........

sorry for that mistake....I should be more watchful while replying............