snyperj
asked on
Linking MS Project to Sql Server
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.
ASKER
Project Server is not an option.
"you need to start some custom development in Microsoft Project's VBA. You can of course read from SQL Server and update dates for specific tasks. However this needs to be triggered by the project manager after opening his/her project"
This is what I am interested in learning how to do in Project. I am familiar with VBA from Access... just need to be pointed in the right direction. Where can I find more info?
"you need to start some custom development in Microsoft Project's VBA. You can of course read from SQL Server and update dates for specific tasks. However this needs to be triggered by the project manager after opening his/her project"
This is what I am interested in learning how to do in Project. I am familiar with VBA from Access... just need to be pointed in the right direction. Where can I find more info?
You may elect to store your VBA in Access. Include the Project reference libraries in your VBA project. This would permit an Access switchboard to be used to fire the code.
FYI, Project is an Access database (Jet)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
have you thought about Projectserver already? With this ALL project data resides in a SQL Server anyway and Projectserver also offers an API to sync data from external systems e.g. your business system. If you don't want to go this way you need to start some custom development in Microsoft Project's VBA. You can of course read from SQL Server and update dates for specific tasks. However this needs to be triggered by the project manager after opening his/her project as there is literally NO reliable way to "remote control" Project and push the sync.
Hope this helps
Thomas