Access table to XML [modified]
-
I have extracted some Outlook contacts to Access table and I now I want to create a xml document that has the below structure. I'm thinking of loading the data to a recordset and then to stream it to an XML document. The problem is how could I define the structure I need for my xml document. Could the xml Microsoft XMLDOM object have as parameter a xml style sheet file....or what? Thank you Leonidas Kallis KundenListe> Kunde> KundenDaten> Anschrift> AdrAnrede s="Κύριος"/> AdrName s="Παππας"/> AdrVorname1 s="Ιωάννης"/> AdrStadt s="Δρυός"/> AdrPostfach s="234242"/> AdrTel1 s="210 4428686"/> AdrLand s="GR"/> AdrPlz s="84400"/> /Kunde> /KundenDaten> Kunde> KundenDaten> Anschrift> AdrAnrede s="Κυρία"/> AdrName s="Τρίμμη"/> AdrVorname1 s="Αγαθή"/> AdrStrasse s="Γαμβέττα 43"/> AdrStadt s="Θεσσαλονίκη"/> AdrTel1 s="2310 677933"/> AdrTel2 s="697 χχχ χχχχχ"/> AdrTelefax s="2310 988290"/> AdrLand s="GR"/> /Kunde> /KundenDaten> /KundenListe> -- modified at 4:15 Tuesday 24th July, 2007