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