连接Excel

odbc
            string str = @"Driver=Microsoft Excel Driver (*.xls);Dbq=c:/abc.xls;";
            con = new OdbcConnection(str);
            da = new OdbcDataAdapter("select * from [sheet1$]", con);
            dt = new DataTable();
            da.Fill(dt);
            dataGrid1.DataSource = dt;

oledb

            string str = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:/abc.xls;Extended Properties=Excel 8.0;";
            con = new OleDbConnection(str);
            da = new OleDbDataAdapter("select * from [sheet1$]", con);
            dt = new DataTable();
            da.Fill(dt);
            dataGrid1.DataSource = dt;