data connection to ms excel
-
hi yall i am a student and am finding it difficult to connect to ms excel. pls assist
-
hi yall i am a student and am finding it difficult to connect to ms excel. pls assist
Hi , Dim DS As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection MyConnection = New System.Data.OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=C:\myData.XLS; " & _ "Extended Properties=Excel 8.0;") ' Select the data from Sheet1 of the workbook. MyCommand = New System.Data.OleDb.OleDbDataAdapter( _ "select * from [Sheet1Name]", MyConnection) DS = New System.Data.DataSet() MyCommand.Fill(DS) MyConnection.Close() Hope This code will help u............:-> Reagrds, Ritesh
-
Hi , Dim DS As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection MyConnection = New System.Data.OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=C:\myData.XLS; " & _ "Extended Properties=Excel 8.0;") ' Select the data from Sheet1 of the workbook. MyCommand = New System.Data.OleDb.OleDbDataAdapter( _ "select * from [Sheet1Name]", MyConnection) DS = New System.Data.DataSet() MyCommand.Fill(DS) MyConnection.Close() Hope This code will help u............:-> Reagrds, Ritesh
Is this possible? copy coversheet1 from test.xls in c:\test directory paste or create coversheet1 to test2.xls in c:\test2 directory both excel documents exist but I need to transfer a sheet from one document to the other. I am using visual basic 6. Any help would be greatly appreciated. Thanks Beginner in VB.Net