Author: miguelangel197 | Posted on: 12/8/2008 8:35:38 AM | Views : 380

 Hi ,
 
I am using this code to open xsl files in .net
 
 Dim MyConnection As System.Data.OleDb.OleDbConnection
                Dim DtSet As System.Data.DataSet
                Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
                MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='D:\BenzTravel\" + name + "';Extended Properties=Excel 8.0;")
                MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection)
            &nbs ...

Go to the complete details ...