sir I have a large project tracking database used to track PMs, status, help needed, action items, reports etc. I keep the project schedule in a large MS-Project file. I've exhausted all efforts to have my organization invest in an MS-Project server. How can I use the data found in my project file: Task Name, Resource, Start Date, End Date... etc as source data into my access database. Can these files be linked somehow if I put the project ID# into my project file as a foreign key? I just need to make the data available to people other than the PM. Ideas?

how can multiple MS project file can be view in one ms access or excel or any other application

  • Select cells in Microsoft Project >> Open Excel Paste special >> Paste link functionality and select As "Text", if that's kinda functionality you are after try checking this link out answers.microsoft.com/en-us/msoffice/forum/… – Shivam Kumar Feb 8 '17 at 11:15
  • There is Microsoft Project Oledb provider available as well which you can use to connect to your project .mpp file from within Access or Excel. – Shivam Kumar Feb 8 '17 at 11:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.