Question MS Access with MS Project & P6 Schedules

[Matt15]

Hi All, I’ve been asked to build an application (in VBA) that can read MS Project and Primavera P6 schedules into the same access database. Has anyone out there built such a database before (and have samples of code)? – One that can cater for all the different fields used by these applications? Many thanks for your help.
Matt

 

[HiTechCoach]

Sounds like a very custom solution.

I would be very surprised if you can find anything for free that does a lot of what you need.

Found this:

You can use the Project Server Interface (PSI).

There is a full SDK available:

http://msdn.microsoft.com/en-us/library/ms512767.aspx

Check out the section on the reporting database as well:

http://msdn.microsoft.com/en-us/library/ms510779.aspx

Of course, you can always use the object model, but you will see performance problems when accessing timephased data. The reporting databse denormalizes all timephased data into views that are very easy to query against.

Colby Africa http://colbyafrica.blogspot.com

I know nothing about Primavera P6 except that it is now owned by Oracle.

 

[Matt15]

Hi, many thanks for the reply.
I agree, finding something ready made is going to be difficult so if there is anyone out there who is sure that they can do it, I'd be really glad for them to quote me!
thanks, Matt

 

[HiTechCoach]

Hi, many thanks for the reply.
I agree, finding something ready made is going to be difficult so if there is anyone out there who is sure that they can do it, I'd be really glad for them to quote me!
thanks, Matt

Matt,

Unfortunately there is no way anyone should be able to know if what you want is possible or even begin to give you any reasonably quote. You have not given any detail on what the application must do.

... read MS Project and Primavera P6 schedules into the same access database

Setting up the linked tables would take a few minutes once all the ODBC stuff is set up. Then Access would be able to read data from both application. Is that really all you need?

 

[Matt15]

Hi Boyd, may thanks for the response again. The application is a bit more complicated than that though at the heart of it is the ability to read in P6 and Project files to a common database. I take your point about not enough information so I'll take a bit of time and write it up properly, thanks for your help, Matthew