?
Solved

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

Posted on 2016-09-06
2
Medium Priority
?
135 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 2000 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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

771 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