Solved

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

Posted on 2016-09-06
2
124 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

717 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