• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

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

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
koughdur
Asked:
koughdur
1 Solution
 
xtermieCommented:
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
 
koughdurAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now