Hi All,
I've created a access database using access 2016. This db is an airport database. It regroups the data that will be used by two differents software.
I'm here now because I need to export my db in a specific way and in a xml file. But I don't know how to do this.
The result I need to get after export is this :
This is only a small part of the data I need to export.
At first I thought of a query I could export but I got stock because I didn't know how to deal with the fact sometimes two differents data have the same name and how to deal with the tags :
<AiportList>
<RunwayList>
<Runway>
<QfuList>
<Qfu>
...
Then I thought of creating a module (a public function) where I could structure the code like I want. But I don't know how to do it. I don't really like the idea of a query because I don't think it's usefull to store the data in it as the data is already stored in the tables, you can't use tags and you can't name two differents data the same way. But I'm maybe wrong.
PS: I forgot to mention that the export will occur after the user clicks on a button in a form.
Thank you for your help,
Mat
I've created a access database using access 2016. This db is an airport database. It regroups the data that will be used by two differents software.
I'm here now because I need to export my db in a specific way and in a xml file. But I don't know how to do this.
The result I need to get after export is this :
Code:
<Database>
<AirportList>
<Airport>
<Name>BOSTON(LOGAN).MA</Name>
<State>MASSACHUSETTS,US</State>
<City>BOSTON</City>
<Icao>KBOS</Icao>
<Iata>BOS</Iata>
<Latitude>42210000N</Latitude>
<Longitude>-71000000W</Longitude>
<Elevation>6</Elevation>
<MagneticVariation>-1600000W</MagneticVariation>
<Comments>Hours of operation:</Comments>
<LastUpdate />
<RunwayList>
<Runway>
<MagneticHeading />
<MagneticHeadingDate />
<Strength />
<MaxLength />
<Width>46</Width>
<Shoulder />
<Comments />
<LastUpdate />
<QfuList>
<Qfu>
<Name>04R</Name>
<Ident />
<Applicability> </Applicability>
<Asda>3050</Asda>
<Lda>2697</Lda>
<Toda>3050</Toda>
<Tora>3050</Tora>
This is only a small part of the data I need to export.
At first I thought of a query I could export but I got stock because I didn't know how to deal with the fact sometimes two differents data have the same name and how to deal with the tags :
<AiportList>
<RunwayList>
<Runway>
<QfuList>
<Qfu>
...
Then I thought of creating a module (a public function) where I could structure the code like I want. But I don't know how to do it. I don't really like the idea of a query because I don't think it's usefull to store the data in it as the data is already stored in the tables, you can't use tags and you can't name two differents data the same way. But I'm maybe wrong.
PS: I forgot to mention that the export will occur after the user clicks on a button in a form.
Thank you for your help,
Mat