Solved

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

Posted on 2016-09-06
2
60 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 17

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
blinking flashing cursor while in MS Word 8 54
Passing a TempVar to a Combo box form 3 84
How to replace  : with / in excel column 4 63
TSQL DateADD update Question 4 31
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

862 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now