Import XML file to Access 2007

[Nigel Molesworth]

I've got a bunch of data created by a navigation program (see sample below)
and I'd like to import it into Access. The aim is to eventually import it
into another program, after I've munged it a bit!

I tried giving the file an .XML extension, and Access had a go at importing
it as an XML file, but didn't actually import any data.

Any tips or clues?



<?xml version="1.0"?>
<NavObjectCollection created="20070724T091959Z">
<Name>Navigation Objects</Name>
<Visible>true</Visible>
<ViewSettings created="20070724T092659Z">
<Position>43.478016 N 16.474313 E</Position>
<Scale>250000</Scale>
<Quilting>true</Quilting>
<ShowRasterCharts>true</ShowRasterCharts>
</ViewSettings>
<Mark created="20070728T171925Z"
id="{e9763c9a-d1ac-4ff3-b232-9b82dc21a5e1}">
<Position>43.545790 N 16.398511 E</Position>
<Icon>Red Anchor</Icon>
<ArrivalCircleRadius>0.05 NM</ArrivalCircleRadius>
<RangeCircleRadius>0 NM</RangeCircleRadius>
<NameOffset>0,8</NameOffset>
<DescriptionOffset>0,24</DescriptionOffset>
<ExistsOutsideCollection>true</ExistsOutsideCollection>
<Name>Marina Kastela</Name>
</Mark>
</NavObjectCollection>

 

[gllincoln]

Hi Nigel,

Not sure what the difference is but using Access 2007 here I was able to cut
and paste your XML into notepad, save the file, and then import it. Just
used the External Data, XML File and selected the file I had created (I
named the file xmltext.xml could be the extension makes a difference
somehow?).

Should be noted that the data has three segments so it imports into three
structures/tables

ViewSettings, Mark, and NavObjectCollection

Hope this helps!

Gordon

 

[Nigel Molesworth]

Not sure what the difference is but using Access 2007 here I was able to cut
and paste your XML into notepad, save the file, and then import it. Just
used the External Data, XML File and selected the file I had created (I
named the file xmltext.xml could be the extension makes a difference
somehow?).

Hi, I did exactly the same, but I got a bunch of errors.