excel

DataSet ds; string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =C:\\Users\\karen\\Desktop\\qq.xls;Extended Properties=Excel 8.0"; OleDbConnection conn = new OleDbConnection(strCon); string sql = "select * from [Sheet1$]"; conn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, strCon); ds = new DataSet(); myCommand.Fill(ds, "[Sheet1$]"); conn.Close(); dataGridView1.DataMember = "[Sheet1$]"; dataGridView1.DataSource = ds;