string cnString="Provider=msdaora.1;Data source=Name; "; cnString=cnString+"user id=UserName;passWord=Password"; try { OleDbConnection cn=new OleDbConnection(cnString); cn.Open(); try { string s="select * from Name.TableName"; OleDbCommand cmd=new OleDbCommand(s, cn); OleDbDataReader dr=cmd.ExecuteReader(); Excel.Application xlApp = new Excel.Application(); if (xlApp==null) { MessageBox.Show("Can't open Excel!"); return; } xlApp.Application.Workbooks.Add(true); int row=2, fieldcount; fieldcount=dr.FieldCount; for (int col=0; col<fieldcount; col++) xlApp.Cells[1, col+1]=dr.GetName(col); while (dr.Read()) { for (int col=0; col<fieldcount; col++) xlApp.Cells[row, col+1]=dr.GetValue(col).ToString(); row++; } xlApp.Visible =true; xlApp=null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cn.Close(); } }