Hello there,
well i have the prob. during the conversion from XML to Excel. When i open an XML file in Excel it works fine except it shows number fields for 2 times in Execl.
how to resolve it ??????
Here is the XML file

  <?xml version="1.0" ?>
- <!-- Generated by Oracle Reports version 6.0.8.18.0
  -->
- <GL_GLLEDGBANK111>
- <G_MDATE>
  <REF_DATE>28-JUL-04</REF_DATE>
  <INST>- CASH</INST>
  <PARTICULERS>CASH</PARTICULERS>
  <MDATE>02-Aug-04</MDATE>
  <VOUCHER>2085</VOUCHER>
  <DEBIT>200000</DEBIT>
  <CREDIT>0</CREDIT>
  </G_MDATE>
 </GL_GLLEDGBANK111>

and the output in Excel file generates the voucher,credit and debit fields for 2 times.

How are you trying to open it? I opened it as a list and let Excel create a schema and it showed as expected, just seven cells of data.


--

Joe (Microsoft MVP - XML)