yeah! I know that concept. I'll try to implement that. Thanks a Lot Divyang Mithaiwala!!!! Thanks n Regards, Ramya.R

why do u explictly need to create notepad ? coz if u want to save data from some text box then there are many file handling operations are there. Divya Rathi

Chk these links http://forums.aspdotnetstorefront.com/showthread.php?p=4424#post4424 Another method http://www.pointercorp.com/Excel2XML.htm You need to do some changes to get the required output

You can use dataset.GetXml method to get the xml private const string xcel_CONN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;"; internal DataSet GetExcelDataToDataSet(string filepath, string sheetname) { OleDbConnection cn = null; OleDbDataAdapter da = null; DataSet ds = null; try { cn = new OleDbConnection(string.Format(xcel_CONN_STRING, filepath)); cn.Open(); da = new OleDbDataAdapter(string.Format(xcel_sql, sheetname), cn); ds = new DataSet(); da.Fill(ds); return ds; } catch (Exception ex) { throw new Exception(ex.Message); } finally { if(cn != null) { cn.Close(); cn.Dispose(); } } }

Thanks alot Richard......... :cool: Im new to Xml,Excel and VBA.Your Code Works Fine.. Once again thanks For yor Help....:cool: :rose: Thanks n Regards, Ramya.R