linking SQL data to Project 2007

[ProjectNewbie]

I have a SQL db containing info on multiple, on-going IT development
projects. These are updated by developers and customers by web interface. I
am trying to dynamically link this data to Proj2007 for predicting future
scheduling, etc. Where can I find info on how to do this. I am unable to map
multiple db tables/fields to one Project file. I'd be grateful if someone
could point me in the right direction. We don't have Project Server (and it's
not likely we will get it). Thanks much!

 

[Rod Gill]

Hi,

You can't link from a database to Project (or Excel or Word for that
matter). Your only solution is a VBA macro that reads data from the database
and updates the projects. For this to work your db needs to hold unique ids
for all tasks and resources with updates.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx