C
Chris Walters
Hi,
I have a query that I'd like to get an answer for, you'll have to bear with
me a little, not being a programmer at all.
We have a projects database where we store various bits of reporting and
attribute data about our projects. Culturally, we're not mature enough to do
a full EPM solution yet, so we're stuck with this database for a while.
If I'm storing informations for task dates (forecast, plan, actual) and
other pieces of project information, is there any way of doing some kind of
automatic or macro-driven connection from MS Project (2000 I'm afraid) to
this database, pull the necessary data out, and have it in MS Project. I've
looked at using Excel as an intermediate format, which is pretty clunky to
be honest, so I'd like to be able to do it in one hit if at all possible.
I've seen how the outline levels work within the Excel export, and could
generate a database view that produced such a structure and could be
accessed through an ODBC connector, and I have a preferred visual feel in
Project... just really missing the bit in the middle.
What I'm trying to get out is a portfolio plan (no dependencies or linkages,
just pure start / ends) showing overall project starts / ends / durations,
with the various attributes that will allow us to cut the reports directly
from project.
Has anybody tried to do this, or similar, or have any hints they could pass
on?
Many thanks,
Chris
--
_____________________________________________________
Chris Walters
Hungerford, UK
_____________________________________________________
I have a query that I'd like to get an answer for, you'll have to bear with
me a little, not being a programmer at all.
We have a projects database where we store various bits of reporting and
attribute data about our projects. Culturally, we're not mature enough to do
a full EPM solution yet, so we're stuck with this database for a while.
If I'm storing informations for task dates (forecast, plan, actual) and
other pieces of project information, is there any way of doing some kind of
automatic or macro-driven connection from MS Project (2000 I'm afraid) to
this database, pull the necessary data out, and have it in MS Project. I've
looked at using Excel as an intermediate format, which is pretty clunky to
be honest, so I'd like to be able to do it in one hit if at all possible.
I've seen how the outline levels work within the Excel export, and could
generate a database view that produced such a structure and could be
accessed through an ODBC connector, and I have a preferred visual feel in
Project... just really missing the bit in the middle.
What I'm trying to get out is a portfolio plan (no dependencies or linkages,
just pure start / ends) showing overall project starts / ends / durations,
with the various attributes that will allow us to cut the reports directly
from project.
Has anybody tried to do this, or similar, or have any hints they could pass
on?
Many thanks,
Chris
--
_____________________________________________________
Chris Walters
Hungerford, UK
_____________________________________________________