Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Using P6 Database in Excel

In the Open Standard
F AMember for 14 years 1 month
Created
3
5
0

Hello All,

 

I'm trying to have p6 data in excel for various reporting purpose. Instead of copy pasting i decided to use Microsoft query to access the p6 database tables.

I'm having problems to identify the specific tables i need to use. I found Task table quite helpful but it doesnt display baseline dates or progress. I assume i need to join to two tables to get the result i need. But i have no knowledge of my project number in the table. the Proj_id which i knw is not displayed in table such as Activtiy.

 

HAs anyone worked on something similar. Could you provide some guidance on it.

 

Thanks

F A

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    see if my post in the other

    see if my post in the other forum helps 

    http://pmsite.com/forums/viewthread/3373/

    Report
  2. 0
    F A ·
    #2

    Thanks Zoltan. But the

    Thanks Zoltan. But the problem here is it's a huge database with lots of projects. How to identify the project u need in the database. Each project is assigned a projectobjectid in the database. Is there a way to identify that. Has anyone tried using the p6 database in excel. Appreciate any help.
    Report
  3. 0
    Zoltan Palffy ·
    #3

    have you tried using sdk ?

    have you tried using sdk ? and the assoicated spreadsheet 

    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?