Importing Project 2007 XML data into Access 2007

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing XML Data in Access 2003 1
Problem importing data into linked table 2
Heirachial XML 1
Importing excel into access 2
XML Import into Access 2007 2
Importing data from Tables into Forms 1
importing tables in proper format from word 2007 into access 2007 2
Linking Access 2007 to Microsoft Project 2007 5

Top