Answered MPP Extraction for MS 2003 project in dot net

  • Friday, July 10, 2009 12:37 PM
     
     

    I am using MS Project 2003 interop and want to dump all data from .mpp file to database.
    I have created database using Microsoft MS Project 2003 script provided in setup.

    Now i am getting all the values from interop object model
    e.g. MSProject.Project properties like ActualStart,ActualWork etc.

    I am unable to map these properties to database columns.
    e.g MSP_PROJECTS table has only 69 columns and
    MSProject.Project properties are around 274.

    moreover i am not clear if properties are giving me all the required values as per table.

    Query
    1.If above approach of extraction is right ?
    2.If yes i need mapping for same.

    Note: I dont want to use OLE DB, ODBC , mdb approaches for MPP extraction of data.


    Thanks & Regards Ajay Singh

All Replies