S Sijin Joseph Aug 13, 2004 #2 You can use ADO.Net and use the Excel Driver to load data from the Excel sheet into the dataset.
A Akhil Aug 13, 2004 #3 I used this and got an error as "Unknow provider in connection object" strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strPostedFileName & ";" & _ "Extended Properties=Excel 8.0;"
I used this and got an error as "Unknow provider in connection object" strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strPostedFileName & ";" & _ "Extended Properties=Excel 8.0;"
C Cor Ligthert Aug 13, 2004 #4 Have a look here http://www.connectionstrings.com/ http://www.able-consulting.com/ADO_Conn.htm I hope this helps? Cor
Have a look here http://www.connectionstrings.com/ http://www.able-consulting.com/ADO_Conn.htm I hope this helps? Cor
P Paul Clement Aug 13, 2004 #5 On Fri, 13 Aug 2004 10:25:10 +0530, "Akhil" <asdads> wrote: ¤ Hi All, ¤ ¤ How to import data from Excel to dataset? ¤ Code please,if Possible. Dim ConnectionString As String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=e:\My Documents\Book20.xls;Extended Properties=""Excel 8.0;HDR=NO""" Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString) ExcelConnection.Open() Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from [Sheet8$]", ExcelConnection) Dim ds As New DataSet("Workbooks") da.Fill(ds, "Sheet8") Paul ~~~ (e-mail address removed) Microsoft MVP (Visual Basic)
On Fri, 13 Aug 2004 10:25:10 +0530, "Akhil" <asdads> wrote: ¤ Hi All, ¤ ¤ How to import data from Excel to dataset? ¤ Code please,if Possible. Dim ConnectionString As String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=e:\My Documents\Book20.xls;Extended Properties=""Excel 8.0;HDR=NO""" Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString) ExcelConnection.Open() Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from [Sheet8$]", ExcelConnection) Dim ds As New DataSet("Workbooks") da.Fill(ds, "Sheet8") Paul ~~~ (e-mail address removed) Microsoft MVP (Visual Basic)
