Opening P6-SQL-Datababase with Excel
In the Open Standard
Hannes de BruyneMember for 21 years 2 months
- Created
- 0
- 6
0
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
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
Replies
Oldest firstNo replies yet. Be the first to answer.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?