P6 XML load into MS Access

Hello,

 Has anyone loaded a P6 XML into MS Access tables? It almost works. I have tried using p6apibo.xsd in conjunction with the XML but it didn't quite work. Just loading the XML directly creates and populates most of the tables you would expect but some tables that should have a key don't.  I had previously used the XER Parser and loaded the tables into MS Access and have a number of queries that I find useful. It would be quicker to just directly load the XML if it loaded the tables properly. Does anyone have the Schema associated with the P6 XML file? Curious if anyone has looked at this.

            Regards,

            Tom Leahy

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts