OleDbConnection Connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\DataBase2.xls;" + "Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";"); OleDbDataAdapter Adapter = new OleDbDataAdapter("Select * from Sheet1", Connection); DataSet DS = new DataSet(); DataTable DT = new DataTable(); Adapter.Fill(DS); DT = DS.Tables[0]; TextBox[,] TB = new TextBox[DT.Rows.Count, DT.Columns.Count]; for (int i = 0; i < DT.Rows.Count; i++) { for (int j = 0; j < DT.Columns.Count; j++) { TB[i, j] = new TextBox(); TB[i, j].Parent = this; TB[i, j].Size = new Size(30, TB[i, j].Size.Height); TB[i, j].Location = new Point(20 + j * TB[i, j].Size.Width, 20 + i * TB[i, j].Size.Height); TB[i, j].Show(); } } int row = 0, col = 0; foreach (DataRow DR in DT.Rows) { for (col = 0; col < DT.Rows.Count; col++) TB[row, col].Text = DR[col].ToString(); row++; }