Importing Project 2007 XML data into Access 2007

  • Thread starter Thread starter Philippe De Ridder
  • Start date Start date
P

Philippe De Ridder

Hello,
I have:
1) exported Project 2007 data into XML format (Save As option).
2) created the tables in Access 2007 db using file mspdi_pj12.xsd available
in Project 2007 SDK (11/2007). Addtional info can be found here:
http://msdn.microsoft.com/en-us/library/bb968664.aspx
Tables have been created OK, except TimePhasedData table (only
TimePhasedDataType "table" is available, which is in fact a complex data type
definiton.
3) imported the actual MS project data XML file (append rows mode). The
embedded data structures are not imported.

It seems this compex type of data structures need to be stored in secondary
tables with some link (foreign key ?).
How can this be done ?

Thanks for your help !

Philippe

Cross-posted to microsoft.public.project.developer
 
Back
Top