none
How to import or transfer data from oracle table to mpp file. RRS feed

  • Question

  • Hello,

    I want to transfer project related information from oracle table to mircosoft project (MPP) file. i am able to generate the mpp template from oracle forms application but dont know how to transfer the task related data to the mpp file from oracle. some one please help me.

    Thursday, September 4, 2014 2:42 PM

All replies

  • There are several ways to do it, one would be to export the oracle data in Excel and then import it into MPP (see this link http://office.microsoft.com/en-us/project-help/export-or-import-data-to-another-file-format-HA010352531.aspx#BM2)

    Other way would be to use a Macro in MPP and use that to read data from table and generate the tasks in MPP, followed by a save

    to learn more, read this http://masamiki.com/project/macros.htm 

    let us know, if this helps


    Thanks | epmXperts | http://epmxperts.wordpress.com

    Thursday, September 4, 2014 5:22 PM
    Moderator
  • Thank you for the quick response.

    First soluction i have already tried and it is working but the problem is the amount of data transfered is large.

    second one is a good option.

    I have a question here, is there any way to write a new task to mpp file using vbscrit. please advice since i dont have much expertise in vba.

    Thanks in advance.

    Friday, September 5, 2014 5:08 AM
  • Yes with VBA you can read write modify delete tasks from MPP, a simple example to add tasks to MPP using VBA would be like this

    Sub AddNewTask()
    For X = 1 To 20 ' Loop through Excel sheet

        SelectTaskField Row:=1, Column:="Name"
        SetTaskField Field:="Name", Value:="T" & X ' Set value from excel sheet
    Next X

    End Sub

    You might want to read the link i provided earlier, which has loads of examples on how to work with VBA


    Thanks | epmXperts | http://epmxperts.wordpress.com


    Friday, September 5, 2014 12:31 PM
    Moderator