View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francesco Sblendorio Francesco Sblendorio is offline
external usenet poster
 
Posts: 12
Default Trouble with fields order of imported XML files

I've imported the XML file reported at the bottom of this post.
It has 4 field in this order: NOME, COGNOME, INDIRIZZO, CITTA.

Importing this file into Excel, the fields order is altered into:CITTA,
COGNOME, INDIRIZZO, NOME. It seems alphabetical order.

How can I avoid this effect?
Thanks in advance again.

--XML FILE-------------------

<?xml version="1.0"?
<MODULE1
<RIGA
<NOMEFrancesco</NOME
<COGNOMESblendorio</COGNOME
<INDIRIZZO32</INDIRIZZO
<CITTABitonto</CITTA
</RIGA
<RIGA
<NOMEGurzo</NOME
<COGNOMEGurzi</COGNOME
<INDIRIZZO45</INDIRIZZO
<CITTABorneo Meridionale</CITTA
</RIGA
<RIGA
<NOMECico</NOME
<COGNOMEPolmone</COGNOME
<INDIRIZZO77</INDIRIZZO
<CITTABari</CITTA
</RIGA
<RIGA
<NOMELippo</NOME
<COGNOMETippo</COGNOME
<INDIRIZZO433</INDIRIZZO
<CITTARitonto</CITTA
</RIGA
<RIGA
<NOMEPeppino</NOME
<COGNOMEPuzzone</COGNOME
<INDIRIZZO2222</INDIRIZZO
<CITTAJappone</CITTA
</RIGA
</MODULE1