Linking MS Project to Sql Server
Posted on 2011-09-13
Currently we have users using MS Project 2003 & 2007. Our main business system resides in a SQL Server 2005 db. Is it possible to read data, from the SQL Server db inside MS Project? We are specifically looking to keep dates in sync. Dates are originally inputted in the business system and PM's enter them in MS Project as well... the trouble is keeping them in sync. The dates can be volatile...so we are looking for a way to see if we can tie Project to the SQL db and somehow change them automatically in Project? Sounds impossible to me but it would be wonderful if we could do that somehow... Thanks.