Skip to content
ProjectControls.com
Oracle Primavera - PM6

link excel to p3

In the Open Standard
Rick AquinoMember for 21 years 6 months
Created
5
1
0
Hi Guyz,

Is it possible to link excel to P3? for updating the progress, for example i’m updating my activities in excel and every activities i updated to excel automatically updated to p3.Is that possible?if not,mafi muskila i’ll just update it in a conventional way.

Cheers

Rick
Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Patricia Le Clainche ·
    #1
    Hello Rick,
    My opinion is that you should better work directly in P3, and then export if necessary to excel.

    I think it is a shame having such a tool and working on excel in parrallele sothat you do the progress update twice.

    Regards.
    Patricia
    Report
  2. 0
    Rodel Marasigan ·
    #2
    Hi Rick,

    There are so many thread in this forum that answer your query. Yes you can used RA Excel utility to update your progress in P3. You can find RA Excel utility on P3CD installation disk under RA util subfolder. It contains Activity.xls, Project.xls, Spread.xls..etc...

    You can also used import/ export module to update P3 using excel.
    Hope this help.

    Rodel
    Report
  3. 0
    Rick Aquino ·
    #3

    Rodel & Patricia,

    THank you for answering my query, i really appreciate that and Rodel thank you for your continuous support in this forum i’m sure some of the guyz there who are very quiet and just absorbing changing of ideas of the active member would thank you guyz for all of your work, including me of course, i learned a lot from this forum.
    Thank you.
    Rick
    Report
  4. 0
    A D ·
    #4
    Rick,

    You can also link excel to P3 with the help of pervasive ODBC drivers. Download the pervasive ODBC drivers and then you can create a database query in excel or MS Access.

    It is far better / easy than using import / export tool in P3. Can check good articles about this on paul harris website http://www.eh.com.au

    Cheers,

    Raviraj A Bhedase
    Report
  5. 0
    Frank Borcherdt ·
    #5
    Rick,

    I would use Ra or Import as these methods will automatically use the autocost rules when updating any field.

    ODBC ignores the autocost rules so you would have to duplicate the impact on the P3 data in your macro/program for each field updated.

    Regards,

    Frank
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?