Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Opening P6-SQL-Datababase with Excel

No replies
Fri, 2009-10-09 03:32
Hannes de Bruyne
User offline. Last seen 1 year 35 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
Hello

some time ago, I wrote that opening the SQL-database with Excel or Access is quit easy and promissed to explain how. I did not find the time untill now, so here is a short explanation for Excel 2007:
Use the Menu:
DATA->GET EXTERNAL DATA->FROM OTHER SOURCES->FROM SQL SERVER

The Servername is YourComputername\primavera
and: Use Windows Access Rights
(for YourComputername see the programm SQL Server Studio express)

Select database: PMDB
Select List e.g. Project (not the one with the double window-symbol but with the singe window)

This must be repeated for other lists like Task or WBS and WBSBudget, then links can be created with "=lookup()" .

Access-Description will follow.

Hannes

Top