Solved

Do standard MS Project mpp files have databases that can be queried?

Posted on 2016-09-06
2
96 Views
Last Modified: 2016-09-07
I have a standard MS Project 2010 mpp file.  I would like to read the data in it by querying it like a database.  I understand that MS Project Servers have databases that can be read, but I'm wondering if just plain vanilla MS Project files also have databases that can also be read.

I tried using ADODB with the following connect string with no success:

Provider=Microsoft.Project.OLEDB.11.0;Project Name=MyMSProjFile.mpp

This string I'm using is one for MS Project 2003 recommended by the ConnectStrings website.  I also tried OLEDB.12, 13, 14, and 15 with no success.

Is what I am trying to do impossible?  Do I just need to use a different connection string?

A complete discussion of how to connect, or why I can't connect would be much appreciated.
0
Comment
Question by:koughdur
2 Comments
 
LVL 18

Accepted Solution

by:
xtermie earned 500 total points
ID: 41787562
The simplest but costy way is called MS Project Server - it stores all data in MS SQL database already, has precalculated reporting database and so on. Here is a link http://technet.microsoft.com/en-us/evalcenter/hh973404.aspx. The last version can be either installed locally or hosted by Microsoft.

Another option I see is to use kind of automation around MS Project which will load project plan, extract all interested information and upload to to your database. There is no big magic in this solution.

The third option is to export projects to XML and then use the XML to upload data to SQL Server database. This solution is also doable through Project automation

After defining your database and column structure in SQL Server, just use Project VBA to A) collect the project and task data into an array, B) set a connection string to your database, then C) send it. I have created several applications around this procedure and it works very well.

There is also a similar discussion here
https://social.technet.microsoft.com/Forums/projectserver/en-US/78e9d2df-e499-4541-9857-c123fe061851/can-i-get-data-from-msp-2010-database-mpp-file?forum=projectprofessional2010general
0
 

Author Closing Comment

by:koughdur
ID: 41788330
Thanks for the ideas and the link.  The export to Access method works, but it's a bit klunky as you have to export three times to get tasks, resources, and assignments.  I think I will either go with exporting to Excel just the customer-requested data (because I can create a map and then reuse that over-and-over), or else use Office Automation.

I was hoping to be able to access the data without opening the file, but it seems that Microsoft deprecated the direct database access capabilities of Project, and although I've occasionally been able to access closed files such as Excel spreadsheets via Office Automation it is usually much more difficult and time-consuming to accomplish fewer tasks.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question