link excel to p3
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
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
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
Rodel & Patricia,
THank you for answering my query, i really appreciate that and Rodel thank you for your continuous support in this forum im 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
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
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